Opening XLS File Already Opened by Excel

Question

I am using Syncfusion 3.3.0.0. How can I open an XLS file that is already opened by Excel (without having to mark the XLS file as 'Shared')? We are only interested in reading the contents of the file, so we want to be able to open the file read-only.

Melba Winshia · Answer

Hi bvanderw,

Support for opening Excel Spreadsheet in read-only mode been added in the later versions. Would it be possible to upgrade to later versions. Use the following code snippets to open an XLS file that is already opened by Excel.

[C#]

//Opening the file.
IWorkbook workbook = excelEngine.Excel.Workbooks.OpenReadOnly(@"..\..\Sample.xls");

Please take a look and let me know if you have any other questions.

Thanks,
Melba