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

Topics

=20
=20

Topics

=20
=20

With ExcelWriter, there is often more than one way to do something, and = these different techniques can have tradeoffs in terms of complexity and pe= rformance.

This topics section offers best practices and guides to compliment the t= utorials section. While the tutorials focuses on how to do something, the t= opics section focuses on when you use certain techniques, and why.

=20
=20
=20

Preprocessin= g vs. Postprocessing

=20

ExcelApplication can be used to either preprocess or post process Workbo= oks. It is important to know when each approach should be used to achieve b= est performance.

=20

How ExcelWriter = Inserts Rows

=20

ExcelWriter interacts with existing Workbook content in two possible way= s when importing data.

=20

Effective Use of Styl= es

=20

Using one of these two techniques to apply styles will use less memory t= han creating a new style for each cell or modifying the Cell.Style property= directly.

=20

Best Practi= ces with Large Reports

=20

It is important to understand that the memory required to process a larg= e report is much greater than the size of eventual output file.

=20

Share= Point Solution - Excel Export Plus

=20

Excel Export Plus is a SharePoint solution that demonstrates a usage of = the OfficeWriter API in SharePoint. This solution adds a new ribbon button = to SharePoint lists, allowing you to export the list data to a pre-formatte= d Excel template that can be designed in Excel or automatically generated b= y Excel Export Plus.

=20

Switching = from XLS to XLSX or XLSM

=20

In ExcelWriter 8, support for the new Open Office XML (OOXML) file forma= ts (XLSX, XLSM) was introduced in ExcelApplication. Since XLSX files have d= ifferent file format defaults and a different file structure than XLS, Exce= lWriter's behavior can change between the two file formats in specific situ= ations. These differences are outlined below.

=20

Intro to PivotTables=

=20

A PivotTable is an interactive table which allows the user to = transpose, filter, sort, and aggregate large amounts of data into a single = table format. ExcelWriter works with PivotTables in two ways: include a Piv= otTable in an ExcelTemplate template file or manipulate PivotTabl= es programmatically with ExcelApplication. This article provides a bri= ef overview on the functionality of PivotTables.

=20

Calcula= tion Engine Supported Formulas

=20

The following formulas are supported by ExcelApplication's calculation e= ngine and will be calculated when Workbook.CalculateFormulas is c= alled. Other formulas will not be evaluated; the display values in those ce= lls will remain blank.

=20

=20

 

 

 

------=_Part_8192_1918784400.1711636961159--