Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

ExcelWriter provides two development solutions that can be used separately or together:
\

The 'ExcelTemplate' Object

Introduction to ExcelTemplate:

ExcelTemplate is the main class for template-driven document generation. This object opens an ExcelWriter template file, populates it with data from a specified data source, and generates a new Excel workbook.
\

The 'ExcelApplication' Object

  • ExcelApplication API Reference
    Icon

    ExcelApplication is not available in ExcelWriterSE.

    Introduction to ExcelApplication: Basic ExcelApplication Tutorial
    \ExcelApplication is the main class for pure code-based workbook generation. This class is an engine used to open, create, and write (save or stream to a browser) workbooks. A single instance of ExcelApplication can generate multiple Excel workbooks.
    \

    The 'SharePointIntegration' Object

  • SharePointIntegration API Reference
    Icon

    SharePointIntegration is not available in ExcelWriterSE.

    SharePointIntegration is a class of extension methods that allow you to more easily use ExcelWriter from within SharePoint, with support for opening and saving from SharePoint List attachments and Document Libraries as well as data binding with SharePoint Objects.

Comparison

ExcelTemplate provides an intuitive high-performance way to import database values to a spreadsheet, but cannot otherwise modify a spreadsheet at runtime. ExcelApplication's rich object model allows you to modify every aspect of the spreadsheet at runtime. You can take advantage of the features of both ExcelApplication and ExcelTemplate by using them together. For example, you can use ExcelTemplate to open and populate an ExcelWriter template, then pass the populated workbook to ExcelApplication and add a chart. Or, you could generate a template spreadsheet with ExcelApplication and pass the spreadsheet to ExcelTemplate to be populated.

  • No labels