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?
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