Message-ID: <1814925242.9975.1711708189314.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9974_2089838161.1711708189314" ------=_Part_9974_2089838161.1711708189314 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html API Reference

API Reference

=20

API Reference

=20
=20

The API Reference describes each object, method, and property in ExcelW= riter.

=20
=20
=20

The 'ExcelTemplate' Object=

=20 =20

ExcelTemplate is the main class for template-driven document generation.= This object opens an ExcelWriter template file, populates it with data fro= m a specified data source, and generates a new Excel workbook. For a quick = introduction to using the 'ExcelTemplate' Object, see the ExcelTemplate Guides.

=20

The 'ExcelApplication' = Object

=20 =20

ExcelApplication is the main class for pure code-based workbook generati= on. This class is an engine used to open, create, and write (save or stream= to a browser) workbooks. A single instance of ExcelApplication can generat= e multiple Excel workbooks. For a basic introduction to using the 'ExcelApp= lication' Object, see the He= llo World Tutorial.

=20

The 'SharePointInt= egration' Object

=20 =20

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

=20

Comparison

=20

ExcelTemplate provides an intuitive high-performance way to import datab= ase values to a spreadsheet, but cannot otherwise modify a spreadsheet at r= untime. ExcelApplication's rich object model allows you to modify every asp= ect of the spreadsheet at runtime. You can take advantage of the features o= f both ExcelApplication and ExcelTemplate by using them together. For examp= le, 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 th= e spreadsheet to ExcelTemplate to be populated.

------=_Part_9974_2089838161.1711708189314--