Format date in excel

Help Activities
, ,
1

My file excel data as below.
image

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

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

2

@fairymemay,

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

change format and save it and try to open through uipath

4

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

5

@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…

6

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

image

Please guide me for solve it.

7

@fairymemay,

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

8

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

9

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

edit.xaml (12.7 KB)

Refer Screenshot:

image
image596×799 19.5 KB

Happy Learning :slightly_smiling_face:

10

Hi @fairymemay ,

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

Regards
Balamurugan.S

11

@fairymemay,

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