.
...
- Result of an attempt to get dynamic formatting based on user choices in asp.net.
- Attempts to autofit column widths after the data has been populated.
- To add special formatting to cells based on their values.
Code Block //* INCORRECT CODE: ExcelTemplate xlt = new ExcelTemplate(); xlt.Open(Page.MapPath(@"path\to\code.xlsx")); /*...*/ xlt.Process(); ExcelApplication xla = new ExcelTemplate(); Workbook wb = xla.Open(xlt); xla.Save(wb, "Completed.xlsx"); */
Issues with this method:
- ExcelApplication fills out everything needed for customization, so when already populated files are passed to it, it requires more for it to load them in than it does for ExcelTemplate alone.
- Performance affected: Memory and Time
...