When i use the write range activity the date format change from the original
How can i make this doesnt happen?
When i use the write range activity the date format change from the original
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?
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
Seems like there is not yet a simple solution to this. Hoping someone else knows better.
References:
I have the same problem… also when I write range from datatable to excel… very strange
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.
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!
Hi
PreserveFormat is working
Thanks for the solution
This is to slow and no performing in big files, more of 60k rows
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.