This tutorial shows how to save Excel sheets into separate files in Advanced ETL Processor. Use it when one workbook contains several sheets that need to become separate outputs without opening Excel by hand.
What You Will Learn
- Split Excel sheets into separate output files.
- Use Excel Writer settings for generated workbook output.
- Work with sheets, tables, and ranges when building the result.
- Avoid manual sheet copying when the job needs to run repeatedly.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
Excel Writer Docs
This tutorial automates Excel sheet output without Excel installed. That is usually better than trusting someone to copy the right tab before lunch.
The supporting Excel Writer documentation covers working with Excel sheets, Excel tables, Excel ranges, creating a new Excel file, adding data into an existing Excel file, and working with Excel tables and ranges.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.