How to clean all the values of all the sheets of an excel file - using Workbook

as the first operation of a stream, I have to clean up all the sheets in an excel file.
I cannot use Excel application, because office it is not installed on the Virtual Machines where the bot will have to be mounted.

? thanks…

Are the files an .xlsx type? UiPath can still read those even if MS Office is not installed on the computer.

The workbook activities should be able to help

Are you able to delete the files and have a new file with the same name put back into the folder location? Might be easier to complete in my opinion. The write activity will create a new excel file if one does not exist in the folder.

1 Like

In fact, it could be the quickest solution!
Sorry for the trivial question.
I still have little experience in this regard.

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