ExcelApplication can be used to either preprocess or post process Workbooks. It is important to know when each approach should be used to achieve best performance.
ExcelWriter interacts with existing Workbook content in two possible ways when importing data.
Using one of these two techniques to apply styles will use less memory than creating a new style for each cell or modifying the Cell.Style property directly.
It is important to understand that the memory required to process a large report is much greater than the size of eventual output file.
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-formatted Excel template that can be designed in Excel or automatically generated by Excel Export Plus.
In ExcelWriter 8, support for the new Open Office XML (OOXML) file formats (XLSX, XLSM) was introduced in ExcelApplication. Since XLSX files have different file format defaults and a different file structure than XLS, ExcelWriter's behavior can change between the two file formats in specific situations. These differences are outlined below.
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 PivotTable in an ExcelTemplate template file or manipulate PivotTables programmatically with ExcelApplication. This article provides a brief overview on the functionality of PivotTables.
The following formulas are supported by ExcelApplication's calculation engine and will be calculated when Workbook.CalculateFormulas is called. Other formulas will not be evaluated; the display values in those cells will remain blank.