Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Intro

Excerpt

Import data to an existing template with multiple charts. Manipulate existing charts with ExcelApplication.

This demo shows how to open an existing Excel workbook and programmatically edit properties of existing charts with OfficeWriter.  Select the major product categories you would like to see in the report.  The SeriesCollection of the existing chart will be changed at runtime to reflect the number and types of categories you choseGenerate a form letter with WordTemplate, then pass it to WordApplication to have formatting applied based on the user's selections.

Intro

This demo's template document is in the format of a standard form letter.  The recipient and author information is inserted into the document dynamically.  You could also write the letter text and image into the document using WordTemplate.

After the form letter is generated with WordTemplate, the document is passed to WordApplication, which then applies formatting (font, font size, etc) based on the user's selections.

Code