tags:

views:

245

answers:

2
+2  Q: 

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

I have a row in excel I'd like to translate into an ObserveableCollection in C# for binding/event purposes, so all accessor classes know they're getting the latest data from the source excel sheet. How would this be done?

Clarification: I'm using an excel add-in project, not a workbook project, so am not sure whether or not XMLMappedRange Controls are an option.

A: 

You can add OnChanged in your range changed event.

PerlDev  2009-12-02 15:25:34
I'm sorry but could you be a bit more specific? I'm using an add-in, not a Workbook project. What assembly would I access the range changed event through?
Daniel Harvey  2009-12-02 18:06:05
I see Microsoft.Office.Interop.Excel.DocEvents_ChangeEventHandler but am not sure if that's what you meant since it seems like it's a document-level handler and not a range-level.
Daniel Harvey  2009-12-02 18:12:20
+2  A: 
Mike Rosenblum  2009-12-07 03:08:57
You're the man Mike! Thanks so much!
Daniel Harvey  2009-12-07 19:39:32
No problem, glad it helped, Daniel. :-)
Mike Rosenblum  2009-12-10 16:27:50

related questions

Displaying Flash content in a C# WinForms application
How to get the value of built, encoded ViewState?
Unhandled Exception Handler in .NET 1.1
How do I connect to a database and loop over a recordset in C#?
How do I most elegantly express left join with aggregate SQL as LINQ query
Get a new object instance from a Type in C#
.NET Testing Framework Advice
Automatically update version number
What is the difference between an int and an Integer in Java/C#?
How to write to Web.Config in Medium Trust ?
WinForms ComboBox data binding gotcha
How do you sort a C# dictionary by value?
Adding Scripting functionality to .NET applications
Floating Point Number parsing: Is there a Catch All algorithm?
How do I print an HTML document from a web service?
Decoding T-SQL CAST in C#/VB.net
Anatomy of a "Memory Leak"
How do I get a distinct, ordered list of names from a DataTable using Linq
Reliable Timer in a Console Application
How do I fill a DataSet or a DataTable from a LINQ query resultset ?
What's the difference between Math.Floor() and Math.Truncate() in .NET?
How do I calculate relative time?
How do I calculate someone's age in C#?
Are there any conversion tools for porting Visual J# code to C#?
When setting a form's opacity should I use a decimal or double?