Uipath change the date format when i read a excel

Help
1

When i use the write range activity the date format change from the original

date
date314×681 3.47 KB

How can i make this doesnt happen?

1 Like
2

Hello @danyboy76, are you copying some cells to other?
If so, could you check if the Cell Format of the source and destination cells are the same?

3

Yes i am copying from cells to cells just a diferent book,
the format of the cells are both general however when i use the write range the the cell change its format to date

4

Seems like there is not yet a simple solution to this. Hoping someone else knows better.

References:

5

I have the same problem… also when I write range from datatable to excel… very strange

6

Hi @danyboy76, if you are reading the input data from Excel, in read range, use PreserveFormat option in property pane.

If still you are facing problem, change the cell formats to text in destination excel file.

5 Likes
7

Ok,

but it’s vary strange if I use a simple copy-and-paste on Excel I don’t have this effect… Why from UiPath have ?

Thank you!

8

Hi
PreserveFormat is working
Thanks for the solution

1 Like
9

This is to slow and no performing in big files, more of 60k rows

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.