0017 Delete sheet from excel files in directory

Delete one worksheet from every Excel file in a folder

This example shows how to loop through Excel files in a directory and delete the same worksheet from each file. It is useful when source files arrive with an unwanted sheet, a temporary sheet, or a sheet that should not be loaded downstream. Test it on copies first. Bulk deletion is efficient, and efficiency is not the same as forgiveness.

Run the example

• Download and install Advanced ETL Processor [Link]
• Download and unzip the example [Link]
• Create a new package and open the .wfp file.

Set the folder path

Double-click the Set Variables action and change the folder path to the directory containing the Excel files.

Select the files to process

Change the file extension if necessary. The package uses the file operation step to find the Excel files that should be processed.

Loop through the files

The loop processes each matching file in the directory. Each file is passed to the delete sheet action before the package moves on to the next file.

Delete the worksheet

The Delete Sheet action removes the configured worksheet from the current Excel file. Make sure the sheet name is correct before running this against production files.

Clean up temporary files

The package can remove temporary files after processing, so the working folder does not fill up with leftovers from previous runs.

Run the package

Run the package by pressing the green arrow. Review the output files after the first run before scheduling the package.

More information

• Delete Sheet Action
• Dynamically create Excel file based on field value