Hello… I have a csv file with many columns one of which is a date. The date in CSV file is in dd-MM-yyyy format. After i use a Read CSV activity the date is changed to yyyy-MM-dd format in the DataTable. And I am writing it as a merged excel (.xlsx ) file.
The CSV file cell format is “Date” and after writing in Excel the cell format is “General”.
I want to retain the same format as the CSV in the Excel too. Please suggest a way.