Format cells of Excel

[Shivaraju (UipathLearner)]

Hi all,
Can anyone please explain how to change the certain column Format cells to Custom type and it should have a length of 8.
Actually I’m copying the data and saving into an excel.In some cases the data is of Integer type and it will start with ‘0’.
Example:-
Present Output:- 2370666
Actual Output:-02370666
Finally what i want to say is I want to add 0 to each row if it has a length<8.

[HareeshMR (Hareesh Madasi)]

HI @Shivaraju,

I got the same issue earlier, but don’t find any solution…

Write Range converting string values to integers

Hi All, I’m trying to read a excel file containing 3 lakh records in it and filtering the data table with some required columns. Then i’m trying to write the filtered table into new sheet. The issue is that , in the actual sheet, Column Name is product ID, my row value is 005300608 which is a string and when i copied the data into new sheet with write range activity, it is converted to 5300608 which is a integer. when i tried to make pivot on that, it is summing up the data in the product ID co…

What i did is, Instead of using the existing activities, i used Invoke code activity to copy and paste the data. In your case, you need to find the length of the string and then you need to add the zero.