Excel Writer

Working with Excel ..

Workshop - Microsoft Excel Writer

Excel transformation

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

Placeholder for Excel Writer

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.

  1. Open the following template in Excel:

C:\Workshop--Data-Integration\Labs\Module 3 - Data Sources\Flat Files\Lab - Excel Writer\template.xlsx

Blank template

SourceData - the datasheet. Transformations write to the required cells that are used to create the graph.

Blnk SourceData

➡️ Next: Write Year

Last updated

Was this helpful?