Hi All ,
Currently we are using DS to excel smart service to download excel file from the grid based on filters .
Problem : In The downloaded excel file lets say Column A is of type TEXT (Its CDT field type is Text in appian ) . Now the business wants it to be integer type in Column A in the downloaded Excel file .
Pre-requiste : We dont want to change the appian cdt type of that field into integer .
Regards,
Vetri V
Discussion posts and replies are publicly visible
vetrivelk
Why don't you try changing the template. Make the column of type integer. The text value from the cdt will not get affected there.
Unlike the Excel Tools smart services like CDT to Excel or SQL to Excel, the DS to Excel OOTB smart service does not allow use of an excel base template at all, which is a big missed opportunity. This means it's not possible to preformat any columns for data type or even for width, headers, filters or the like.
Can you confirm if you are talking about this smart service?
We can provide the excel base template in "Document to update" field.
ankitab0001 said:"Document to update" field.
This field is used to update a different sheet in a workbook already created by another smart service node. This will create a new version of the given document not a copy of the document.