Monday 15 June 2015

monitoring a range of cells inside of excel 2007 with C#/VSTO -


I have a line in excel, I want to translate into an objectionable selection in C # for binding / event purposes. Therefore, all the accessor classes know that they are getting the latest data from the source axle sheet, how will this be done? Explanation: I am using an Excel add-in project, not a workbook project, so I'm not sure whether the XMLMappedRange control is an option or not. You have a few options by using

  1. From the class, you can access this event. . From the
  2. class, you can do this event (which uses the Microsoft.Office.Interop.Excel.DocEvents_ChangeEventHandler representative, which you have used in another comment).
  3. NamedRange class supports simple, only databasing through property, one example of which is shown in the discussion.
  4. Another possibility is control, which also supports the database.

A good primer can be found here: using NamedRange and XmlMappedRange.

I hope it helps ...

Mike


No comments:

Post a Comment