When inserting a value into the cell of an Excel table by the UiPath robot, the formatting of the cell is preserved. Even after saving the file, the formatting is still correct. However, if the file is then closed, then not only will the formatting of all cells on the tab where the value was entered be changed to ‘User defined’, but on all other tabs.
Formatting of the cells before closing the file:
Formatting of the cells after closing the file:
The error happens regardless of whether the robot closes the file itself or whether I check the checkbox for ‘Keep excel file open’ in the configuration of the ‘User Excel File’ activity and I close the file manually.
If I do the process completely manually, edit the file, save and close it the formatting is preserved.
If the robot just opens the file, saves it and closes it without editing it, the formatting is preserved. So the real problem seems to be with the ‘Write Cell’ activity.
How can I solve the problem?