We are using "Parse Excel to CDT" smart service from "Excel Tools" plugin to parse the uploaded rows. doing some validations with uploaded rows, if we find any rows with issues exporting those rows in to Excel using "Export CDT to Excel" Our target is to download the exported excel and correcting the rows and upload again.After downloading the excel all columns in excel showing "General" format Even though we have set a column to Date/Number format (column data type is date/integer as well, database is Oracle) in the excel template, the generated excel does not retain the date format. Is there a way to force excel recognize the cell values as Date/Number for a column?
Discussion posts and replies are publicly visible
Hi vinod alla (vinoda) ,
Plug-in might be doing the date format conversion, As a work around you can do as below1. Create a duplicate cdt exactly what you are currently exporting but keep all the field types as "TEXT".2. Format Excel template cells as Text.3. Move the information for current cdt type variable to Duplicate cdt type (make sure convert your date values to required format).4. Use the Duplicate cdt variable to export.
Converting Date format:a!forEach( items: {pv!cdt.date1}, expression: datetext(fv!item,"MM/dd/yyyy"))
Boolean variable exported to excel as Yes or No if data type is boolean, true or false if boolean type converted to text data type.No mater for boolean, Appian will do auto casting either (true or false) or (Yes or No) to boolean type.
Regards,
Venu.