Excel error

[Anna Srinivasan]

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,
Anna


excelerror.zip

[Chella Pandian B]

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.