Format date in excel

My file excel data as below.

But If I open excel by uipath. It show data as below.

It format date is correct dd/MM/yyyy
Please guide me for solve it.


Can you attach your here?
You can aslo check with Format cells options

change format and save it and try to open through uipath

@Pankaj.Patil File excel and file .xaml as atttched.
ExampleSpreadSheet1.xls (159.9 KB)
edit.xaml (8.7 KB)

@fairymemay - Have you tried Preserve Format in the read range ??? If not, please try that and print the date & check…

I have already shared few workflows with you in the past, where I have showed how to handle this with Preserve format and with Datetime.Parseexact…

@prasath17 If I use preserve format —> It read and write data ###


Please guide me for solve it.


Can you double click on column separator line between F and G?

@Pankaj.Patil How​ t​o use​ UiPath​ click​ separator​ line​ F​ and​ G?

@fairymemay - Please refer the xaml file you excepted output is available.

edit.xaml (12.7 KB)

Refer Screenshot:

Happy Learning :slightly_smiling_face:

Hi @fairymemay ,

Take a look at this video. Using the activity can able to change the format of the cell.



You will have to use Send Hotkey with keys Alt+hoi which will apply autofit on columns.