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.



CSV issue 3

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.