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
Sorry for my bad English. Not my first language.I meant data cleaning step or any data manipulation step.
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
This works for me! Thank you!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.