Read csv - Format

[Birgit_Plank]

Hello,
I would like to import the data from a CSV file into an Excel worksheet.

Unfortunately, the formatting of the CSV is being distorted during import.

In the first row of the CSV, the date is in the format dd.mm.yyyy. However, upon import, the date in the first 6 columns is correct, but in the othter columns the date is reformatted to mm.dd.yyyy.

Additionally, some values have decimal places, for example, 100.50, and in this case, the value is imported as text.

The CSV file is automatically exported from the ERP system in the Windows-1250 format. Can anyone help me with this issue?

[Yoichi]

Hi,

Can you share sample csv and expected output? It’s no problem if dummy data.

Regards,

[rlgandu (Rajyalakshmi Gandu)]

@Birgit_Plank

Please send the input and output Files

[Birgit_Plank]

Unfortunately, as a new user, I am unable to upload anything. I am receiving an error message.

[Birgit_Plank]

Image upload works, that’s the csv

[ppr (Peter Preuss)]

@Birgit_Plank
Perfect in our short session we had set up the trail

• Read CSV will get triggered by e.g. 02.01.2024 (2nd Jan) or 17.04.2024 (17th Apr) - AT Format
• Inspection within the Immediate panel verified - Data Readin was correct
  Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum
• But we would have to check if the column datatable is set /recognized to a DateTime or not
  ** If, the ambigous Dates below the 13th do have a risk of get missinterpreted
  (we found it 02.01.2024 and 17/05/2024 in the out excel)

writing it out to Excel will create some wrong cell formats - but the ambiguous misinterpreted dates cannot be reformated

So we recommend:

• Data cleansing /harmonization - DateTime.ParseExact
• Writing out to Excel
• if needed, cell reformatting
  Activities - Format Cells