WriteRange activity

[pveneziani1 (Pier Filippo)]

I’ve got a problem using write range to an Excel. I built a DataTable with some columns formatted as Double and Others string. When I use this DataTable as input variable for Write Range, the resultant Excel columns are formatted as general.
How can I copy a DataTable to an Excel workbook maintaining the format I set?

[lakshman (Ganta lakshman)]

@pveneziani1,

Use String.Format(yourInputString, “0.00”)

[pveneziani1 (Pier Filippo)]

Should I set all datatable columns format as string then?

[singhonkar (Onkar Singh)]

@pveneziani1

Convert column with double data type to string and keep the datatable to string format.

Later on, if required you can change particular value into your desired data type.