display-medicalExcel Writer

Working with Excel ..

circle-exclamation

Workshop - Excel Writer

Advanced Excel Writer scenario

circle-info

Workshop files

Download the following files.

Keep the filenames unchanged.

Save them in your workshop folder.

file-download
303B
file-download
385B
file-download
22KB
file-download
39KB

Sales & Expenses
circle-info

Create a new transformation

Use any of these options to open a new transformation tab:

  • Select File > New > Transformation

  • Use Ctrl+N (Windows/Linux) or Cmd+N (macOS)


circle-info

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 template.xlsx in Excel:

Blank template
circle-info

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

Blank SourceData

Last updated

Was this helpful?