.
...
| icon | false |
|---|
| Excerpt |
|---|
Preprocessing refers to using the ExcelApplication object to modify an existing partial template file before passing the template file to ExcelTemplate for importing data. Postprocessing refers to using the ExcelApplication object to modify a workbook that has already been populated with data. |
Background
ExcelApplication was designed for the purpose of creating more dynamic content, but as a consequence it is more memory intensive. ExcelTemplate, on the other hand, was designed for the purpose of importing large amounts of data, and much less memory is required per cell for an ExcelTemplate object. To improve the amount of memory that's being consumed, we recommend:
...
For example, you can create a Workbook with ExcelApplication and insert the formatting, charts, or dynamic content that you want to appear in the final workbook, along with data markers where you want the data to appear. You can then open this Workbook with ExcelTemplate to populate the data.
When should I be postprocessing?
Postprocessing should only be done when there are changes that need to be made based on the data that was imported, or when preprocessing is not available.
...