Alex Rivera | Logout

VSTO: Attach meta-data to a cell in Excel?

Asked 2010-01-11T22:33:13.233
13

I'm using VSTO to create an Excel Add-on. This add-on retrieves and display alot of data from a sql-server. This works great, but later on I plan to access some of the data inside excel and modify it in some ways. My problem is that I need a way of classify cells that I want to modify. Is there any way to add meta-data to a cell to know if it is a cell that should be modified? E.g. add a attribute to the cell, e.g. "editable_cell", and do something like Excel.FindCellsWithAttribute("editable_cell") to find the sought after cells?

Thanks!

Edit
Report

1 Answer

1
answered 2010-03-23T20:57:28.617

Your Answer