Number with leading 0 is getting Truncated in Excel

Help Activities
, ,
1

I am reading and writing numbers from one excel to another using a Data Table. I found that the numbers starting with 0, the leading 0s are removed while writing.image
I am using string Data type in the data Table column. (The data table I am copying Excel data to). I am adding the data row in a for loop according to a specified condition:
What am in doing wrong?

2

@Rachita_Chauhan
Excel is recognizing the value as a Number and is removing the leading zeros.

Option 1:
Setting the cell format afterwards with following activity:
grafik

Option 2:
prepend a ’ on the value like '00002356
It is forcing excel to interpretate the values as text

3

I cannot use external package

4

then give a try on

  • the ’ prepend workaround
    Or
  • implement the cell format in change within excel e.g. by macro/vba Code / Click sequence / Shortcut series etc.
5

This is the Solution: using Write Range activity from System >> File >> Workbook . You should use the Read Range activity under the System too.

2 Likes
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.