How to keep the range format and write to new sheet

Hi Experts,

I have download CSV data from website and use uipath to read and write to another new excel sheet, but i found the data range can’t write correct number what website original one,how can i solve it?

on website data
image

after read and write to new sheet (i use read and write range)
image

@Phoebe

Please check the property ‘PreserveFormat’ on the Read Range activity as in the inline screenshot.
Excel format

Hope this will help you. Thank you

@Jobin_Joy

because it’s CSV file, i use “read csv” as picture below, it dont have “preserveformat”
image

look like the leading zeros are eliminating in CSV file? Is that the difference you observed.

Ex:
In Web site: 0000555592000001
In CSV file:55592000001

Is this correct understanding?

@Jobin_Joy

leading zeros eliminated is OK, i only need the whole number excluding leading zero,
EX:
In Web site: 0000555592000001
download CSC file–>555592000001
what i need data–>555592000001
read CSV and write to new excel it turns out → 55500000000
:cry:

here is CSV file download from website
Dispatch.zip (297 Bytes)

@Phoebe

I am getting the results as you expect. Please go through the attached inline screenshot.

Attaching the source code as well.




Hope this will help you. If this is working, kindly mark this issue has been ‘Resolved’.

Thank you.

Code and CSV,XLSX files.zip (8.6 KB)

2 Likes

@Jobin_Joy

it works!!! really appreciate for your great help!! :smiley: :smiley:

1 Like

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