Successive Workbook Opens

[Joseph Nash]

When attempting to open a second (same or different) workbook during an execution the following error is thrown:

An unhandled exception of type ''System.ObjectDisposedException'' occurred in syncfusion.excelrw.dll

Additional information: You can not use dipose object.

code snippet is as follows:

IWorkbook workBook = ExcelUtils.Open(fileName);
/* Read data from worksheet into a grid */
workBook.Close();
ExcelUtils.Close();

What do I need to do to be able ditch the first workbook and get another?

[Administrator]

Hi Joe,

Thank you for your interest in syncfusion Essential ExcelRW.

ExcelUtils.Close(); disposes all the unsaved objects so it will not be possible to access the workbook again. So, Please use this call only at the end when you want to dispose any unsaved objects. Please let me know if that doesnt help.

Best regards,

Stephen.

>When attempting to open a second (same or different) workbook during an execution the following error is thrown:
>
>An unhandled exception of type ''System.ObjectDisposedException'' occurred in syncfusion.excelrw.dll
>
>Additional information: You can not use dipose object.
>
>code snippet is as follows:
>
>IWorkbook workBook = ExcelUtils.Open(fileName);
>/* Read data from worksheet into a grid */
>workBook.Close();
>ExcelUtils.Close();
>
>What do I need to do to be able ditch the first workbook and get another?
>
>
>
>
>
>
>