Data Format Issues in CSV to Excel Conversion

Help
#1

Hi All,
I am working on a requirement in which one csv file needs to be converted to excel.
After conversion, the data format is giving issues in excel like :

image

image

Can anyone help how to resolve this.
PFA: ExlToCsvConversion.zip (17.2 KB)

#2

They are only warnings, which you can ignore.

If you still want to fix them, there are multiple ways

  1. use string functon’s like substring, replace etc…

eg.

str = “10-08-18”
str = str.substring(0,6) + “20” + str.substring(6,2)

str = “'123” //second problem
str = str.replace ("’", “”) //replace ’ by space

  1. format the column

  2. Open CSV and save as excel

#3
  1. As input and output column headers are same there is no need for build datatable.
  2. start date and end date are in date format in csv file. So you need to convert to your specific date format. Find the attached flow for your reference.

CSV_To_Excel_Conversion.zip (17.3 KB)

#4

Thanks @kirti.iyer,
For Date Format its working but for Other columns conversion from string to int or string to double is still having issue.

I tried these as well

row.Item(“Item”) = Convert.TOInt32(row.Item(“Item”))

row.Item(“Item”) = CInt(row.Item(“Item”))