DataTable entered in an Excel file using Write Range doesn’t look the same as the original data.
I have an original Excel File with lots of data inside. I retrieve this data using Read Range to get DataTable object from it.
Then, I use Write Range inputting that DataTable. The action itself works fine, but some numbers are displayed weirdly.
For example, in original Excel, a part of the data looks like
but when I Write Range this using this DataTable, now it looks like
This is merely a part of the problem, and the same problem occurs under other columns where the currency values are displayed improperly.
I don’t understand why this happens. What is confusing is, it doesn’t happen to all rows under the same column. As you can see, some values are copied correctly, but others get so many decimal places values.
Is there any way to fix this? Is this even a UiPath problem?
By the way I click on those corrupted cell on Excel, go to Format, and change the “Currency” or “Number” format to display up to 2 decimal places, but even that doesn’t work. It starts working after I click into those cells and click somewhere else to exit the cell. I am so lost. Can anyone please help?
I attached a .gif file so you can see. I hid other confidential data, but even Excel formatting doesn’t work after Write Range.