Message-ID: <422037752.10155.1711714732222.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10154_452214355.1711714732222" ------=_Part_10154_452214355.1711714732222 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

Preprocessing= 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 I= nserts Rows

=20

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

=20

Effective Use of Style= s

=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 Practic= es 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

ShareP= oint 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 f= rom 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<= /h3>=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

What is Hot Cell Te= chnology?

=20

ExcelWriter's HotCell Technology provides the ability to dynamically ret= rieve or update data on a Web server based on modifications made in an = ;Excel file on a client. HotCell Technology uses Excel VBA code embedded in= the spreadsheet on the client.

=20

=20

 

 

 

------=_Part_10154_452214355.1711714732222--