This tutorial shows how to create a large Excel file with 1 million rows in Advanced ETL Processor. Use it when you need to generate high-volume Excel output without building the workbook by hand.
What You Will Learn
- Generate a large Excel file from source data.
- Use the Excel Writer for high-volume output.
- Understand where Excel sheets, ranges, and tables fit.
- Avoid slow workbook settings when performance matters.
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 uses a demo customer CSV file from github.com/datablist/sample-csv-files.
The supporting Excel Writer documentation covers working with Excel sheets, Excel tables, Excel ranges, creating a new Excel file, cell formatting, and performance notes.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.