Cleaning all files from the same folder without combining it

I have around 100 excel files in one folder and all of the them have the same format.
I want to clean it in one go instead of combining them into one excel file or refresh 100 times. I want to keep them as separate. Is this possible to do it?
Thank you.

Hi @newba

What do you mean by “to clean”. Remove all content, and sheet names? Or remove some specific content? Or remove all excel files and replace them with empty files with the same name?

gr. Hans

1 Like

Sorry for my bad English. Not my first language.I meant data cleaning step or any data manipulation step.

2 Likes

Hi @newba

Your workflow can look like this:

In the Excel reader you use the Path variable for selecting the excel-files.

You can use the same Path variable in the Excel Writer node.

Don’t forget to check “overwrite”. But also be carefull, because there is no way back if you make a mistake. I think it is a good Idea to get your workflow working on some sample excel files.

gr. Hans

5 Likes

This works for me! Thank you!

2 Likes

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