Your program, which uses the ExcelApplication object, is using more memory than you would like or is taking too long to generate a report.
The Best Pratices with Large Reports article in our documentation discusses how to optimize for large ExcelApplication reports by reducing memory or run time. It includes, but is not limited to:
- What to avoid when referencing cells, inserting rows or columns, and applying styles
- Certain methods are known to be memory intensive, such as AutoFitWidth
- Ways to improve performance by changing how and when data is imported
There are also code examples that compare inefficient code and code that was improved by the recommendations in the article. These code examples are split up into Memory Related Performance Issues and Time Related Performance Issues.