Missing leading Zero's in Write range excel activities

I have my records in datatable and loosing zero’s when using Write range activity.
Also, looking for suggestion how to use save as for opened excel.


Convert the data type to string in the excel before writing so that the zero’s will be there and

If you opened the excel using excel application scope, you can use Save workbook activity available :slight_smile:

Can you share in details about convert the data type to string in the excel. ?
I have my data in datatable and using write range to push data.

Did you try to put an ’ (&apos) in front of your string value?
Es: myString = “'” + myString

Thanks. adding ’ is the only solution before preparing the data to dump in Excel with Range .

1 Like