Working with Javelin flows and Export Data Table activity in excel files. The columns that contains numbers (for example when data table type is “Decimal”) are exported in text format, and workarounds are needed to convert directly into excel file.
Is there a solution/suggestion for that?
Javelin 4.11.0.X
By default, existing Export to DataTable activity does set all Excel cells as Strings when exporting.
Attached is an example flow with a few steps added to fix all numbers to be handled as numbers and not strings anymore.