Excel error

Question

Hi,   Please find attached picture for excel error.1) What is root cause of this problem?2) How do we avoid this error?    Kindly help me on this.Regards,Annaexcelerror.zip

Chella Pandian B · Answer

Hi Anna

By Setting the property excelEngine.ThrowNotSavedOnDestroy to false before saving the excel file we can avoid ExcelWorkbooknotSavedException.

ExcelEngine excelEngine = new ExcelEngine();

excelEngine.ThrowNotSavedOnDestroy=false;

workbook.SaveAs("Sample.xls",ExcelSaveType.SaveAsXLS);

Let me know any other queries.

With Regards,
Chella.