Datatype column set to string but leading zeros removed


I am writing a range to an excel file. However, values for one column can contain leading zeros (e.g. 015). When I look at the result, the leading 0 is omitted.
I have set the datatype for the column to string for the specific column, yet it is not reflected when I write the data.

Any hints/tips how to fix this?

Thanks a lot!


give a try with explicit filling up with:

sometimes it helps to put a ’ before the value when writing to Excel

Also have a check on this component from Connect:

Try this: It works: using Write Range activity from System >> File >> Workbook . You should use the Read Range activity under the System too.