Why this might happen:
// 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:
Solutions:
// CORRECT CODE: ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Open(Page.MapPath(@"path\to\code.xlsx")); /*...*/ ExcelTemplate xlt = new ExcelTemplate(); xlt.Open(xla, wb); xlt.Process(); xlt.Save(Page.Response, "Completed.xlsx", false); |
Why this might happen:
Issues with this method:
Solutions:
Why this might happen:
Issues with this method:
Solutions:
Why this might happen:
Issues with this method:
Solutions: