.
| Excerpt | ||
|---|---|---|
| ||
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. |
| Panel | ||||
|---|---|---|---|---|
| ||||
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:
...