This example shows how to delete a sheet from all Excel files in a directory

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

Delete sheet from excel files in directory

  • Double-click on "Set variables action" and change the path

How to rename the file using the current date as part of the file name

  •  Change file extension if necessary

File Operation

How to rename file using current date as part of file name

Delete excel sheet

Delete file

  • Run the package by pressing the green arrow.

More Information

Please contact us if you need help with transforming the data

Visit ETL Tools Forum