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
after read and write to new sheet (i use read and write range)
Please check the property ‘PreserveFormat’ on the Read Range activity as in the inline screenshot.
Hope this will help you. Thank you
because it’s CSV file, i use “read csv” as picture below, it dont have “preserveformat”
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?
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
here is CSV file download from website
Dispatch.zip (297 Bytes)
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)
it works!!! really appreciate for your great help!! 
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
