We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Interact using XlsIO with a currently open Excel Workbook

Thread ID:

Created:

Updated:

Platform:

Replies:

118998 May 3,2015 05:50 AM UTC May 4,2015 10:59 AM UTC WinForms 1
loading
Tags: XlsIO
tttmack
Asked On May 3, 2015 05:50 AM UTC


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 [Syncfusion]
Replied On May 4, 2015 10:59 AM UTC

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


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;