I am simply reading from an Excel file and writing to a new excel file and it works.
I have questions though.
If you see, my source file(dummy1.xlsx - on the left hand side) and my target file(dummy2.xlsx) has different format, although content is exactly same. So why UiPath can’t copy with extact format also? When reading from the file I am using PreserveFormat…I thought it would preserve the format.
Secondly the sizes of the two files are also different.
Dummy1 is 18kb while Dummy2 is 14 kb - probably for the difference in format?