Excel Interop Issues
-
I'm working on an excel application with data validation in it. The boss insists we use form controls such as checkbox or radio button. Is there any way to integrate these into an excel spreadsheet through COM Interop? If so, please provide an example or post a link. Also, we need to read the excel spreadsheet back through COM, so the controls need to be accessible later.
-- Steven Hunt
-
I'm working on an excel application with data validation in it. The boss insists we use form controls such as checkbox or radio button. Is there any way to integrate these into an excel spreadsheet through COM Interop? If so, please provide an example or post a link. Also, we need to read the excel spreadsheet back through COM, so the controls need to be accessible later.
-- Steven Hunt
Have you ever heard of Microsoft Visual Studio Tools for Office (VSTO)? It allows one to automate Excel documents using .NET (in C# or VB). It supports dragging-and-dropping WinForms controls onto the worksheet. In addition, you can cache arbitrary data (e.g. the state of the controls) within the document and retrieve them outside of the Excel host environment. For more information: Visual Studio Tools for Office -Phil Disclaimer: I work for Microsoft as a developer on the VSTO product team.