Csv to excel conversion issue

Help Forum
1

Hi guys,

 I am worked on the csv to excel conversion. In csv all the columns have formats like Date, percentage, double and so on. I am trying to convert into an excel facing challenges like in date column field some are comes in General format in excel and some are comes in Date format.

If it is in date format while conversion then only I have to process further steps.

Kindly suggest some idea, without affecting cell format in the csv need to convert into an excel.

Happy Automation

2

@Iswarya_P1

this might occur because of date formats in csv open the csv in notepad and check and see what values are there when empty and how dates look in csv

cheers

3

Can you suggest any idea to overcome this issue?

4

@Iswarya_P1

How are you trying to convert?

One way is to convert the column type in datatable itself and then write

Cheers