Excel Writer
Working with Excel ..
Workshop - Microsoft Excel Writer
Steel Wheels intends to automate their half-yearly Sales and Expenses Report. The process for extracting, transforming, and loading (ETL) data has been delineated into several workflows. Upon the completion of these workflows, data will be automatically populated in a predefined Excel template.
In this workshop, you will configure the following steps:
Excel Writer
Block Step

Create a new Transformation
Any one of these actions opens a new Transformation tab for you to begin designing your transformation.
By clicking File > New > Transformation
By using the CTRL-N hot key

The following content has been automatically generated by an AI system and should be used for informational purposes only. We cannot guarantee the accuracy, completeness, or timeliness of the information provided.
Any actions taken based on this content are at your own risk. We recommend seeking qualified expertise or conducting further research to validate and supplement the information provided.
Excel Template
The various stages of the transformation write data to a template.xlsx. The template has 2 worksheets:
Sales Chart - this worksheet creates a 3D stacked graph
SourceData - worksheet.
Open the following template in Excel:
C:\Workshop--Data-Integration\Labs\Module 3 - Data Sources\Flat Files\Lab - Excel Writer\template.xlsx


➡️ Next: Write Year
Last updated
Was this helpful?