Hi All,
I'm using for the first time the Export Data Store Entity to Excel Smart Service to add data to an existing excel template (saved as a doc in appian) (Exporting data to a formatted Excel sheet).
Once I add the data to the excel it seems it adds it in the same row and erases anything on the same row that was there before, I'm trying to add the new data only in one column, different rows instead in one whole row.
Does someone know if this is possible or how I should be configuring the parameters.
customCellPositions
List of Text String
(Optional) Array of cell positions where custom cell values should be added.
customCellValues
(Optional) Array of values to be added on the specified custom cell position.
Or if you could recommend a different smart service to achieve this?
Thanks in advance
Discussion posts and replies are publicly visible
Hi,
You can use the parameters by passing customCellPositions (e.g., A1,A2,A3,...) and customCellValues (e.g., 1,2,3,...). This will place the data in the specified cell positions within the Excel file.
However, I'm not entirely sure whether this approach will override any existing content in those cells. It should insert the data as defined, but please test it to confirm the behavior in your specific case.
customCellPositions: {"B2", "B3", "B4"} customCellValues: {"Apple", "Banana", "Orange"}
Yes, I tried this before it would throw an error this:
The starting cell I'm using is "A1"
customCellPositions: {"A1", "A2"}
Custom cell positions cant refer to cells below the starting cell. Otherwise, they would be overwritten by data being exported. (APNX-1-4505-037)
Also, I noticed that for customcellvalues it doesnt let me use it on its own, this is plus the data in the store entity. So it adds both data from the data store entity which is a required parameter and these custom cells.
I want to make sure the one coming from the data store entity is the one I can actually manipulate to put in the specific cells I need.