Delete excel sheet

Hello.

Just wondering if your software can delete a sheet from an Excel file.
We want to remove confidential information before sending it to the customer.

Thank you,
George

Excel Operation action offers a variety of options one of them is delete sheet

/wiki/advanced-etl-processor/packages/actions/excel-operation-action/

You can also check if a sheet exists, add a sheet, rename sheet, check file, change the extension and read cell value.

I have noticed that it is only possible to delete sheets from a single excel file.
Is there a way to do it for all excel files in the directory?

George

You can create a list of files using file operation and loop through the list and process files one by one.

This simple task can be challenging for a new user so we will create a working example for you.

Here it is
www.etl-tools.com/automation/0017-delete...es-in-directory.html