Exporting an xlsx file to csv but not able to format the date format properly_SOLVED

Help Activities
, ,
1

Hello guys,

So, I am building this workflow that should take 3 dynamic “.xlsx” files and make a copy of each and save it as a “.csv” file.

I managed very easy to do it successfully using the “export to csv” activity.

But the problem is the date format on the “.csv” files are wrong.

On the “.xlsx” files the date format are “dd/mm/yyyy” and on the “.csv” files the date format changes to “mm/dd/yyyy”.
Which is causing some issues because after this process another process take these 3 “.csv” files and upload them to a dashboard that just accept “.csv” files and the whole system works on “dd/mm/yyyy” date format.

So, I tried already to use “format cell” activity but there is no option to set a date format as “dd/mm/yyyy”. Tried also changing to custom and “hardcoding” the parameter to “dd/mm/yyyy”, but no success.

I also tried to use “read range”, “write CSV”, activity and none of that worked.

And I am not willing to use dynamic selectors to open the “.xlsx” files and going through the whole process of clicking on “save as” and them changing the extension.

Do you guys have any insight or a tip/hint that could help me?

Thanks guys

2

Hello @8a1c626efd7987241afcbd9fa

If your format if the date is always same and the format of the excel is static , then its better to create a template excel file with all the required formats. Then write your data to that template excel. It will help to preserve the format.

Else you can use Format cell activity to change the format.

Thanks

3

Hello, @Rahul_Unnikrishnan

I tried using the “Format cell” activity, but there is no option for the format “dd/MM/yyyy”.

Also, I tried as well to create a blank csv file where I write the data from the xlsx file using “Read Range” and “Write CSV” activities. None of them worked.