I have to copy a large matrix from a csv file to an excel file. The csv has the “,” as decimal separator and doesn’t have any group separator.
My xaml has two activity:
- Read csv
- Write range.
When I launch my process, the output excel file has a wrong number format, for example:
csv number --> 3,6000
excel number --> 36000.
I changed the decimal and group separator from my Control Panel, but I had the same result. “It seems that UiPath doesn’t consider this modify”.
Does anyone have any suggestions?
PS: I have a large matrix and I can’t format number by number (for reason of time).