Missing leading Zero's in Write range excel activities

[jukkendar_sundaram]

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.

[HareeshMR (Hareesh Madasi)]

@jukkendar_sundaram

loosing zero’s when using Write range activity

@jukkendar_sundaram,

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

[jukkendar_sundaram]

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.

[Mugur (Mugur Munteanu)]

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

[jukkendar_sundaram]

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