Interact using XlsIO with a currently open Excel Workbook

[tttmack]

Is XlsIO only used for reading, generating and creating Excel files that are currently closed or can it also interact with Excel workbooks that are currently open like Microsoft.Office.Interop.Excel?

I was hoping to see if XlsIO might offer some enhanced functionality or performance over Interop, but require it to interact with workbooks that are currently open, not previously saved/created files.

[Ishwarya Narayanan]

Hi Tttmack,

 

Thank you for using Syncfusion products.

 

Yes, we can interact with the currently opened excel workbook using OpenReadOnly method in XlsIO. We have provided a sample to achieve your requirement in the below link. Also you could use the below code snippet to interact with currently opened workbook.

 

Code Snippet:

IWorkbook workbook=application.Workbooks.OpenReadOnly(“Sample.Xlsx”);

 

Sample Link:

http://www.syncfusion.com/downloads/support/directtrac/137895/Forum118998_InteractwithOpenFile-2036293698.zip

 

Please let us know if you need any clarification.

 

Regards,

Ishwarya N