Geek asks and answers

How can I write an Excel plugin that loads a SQL Server data table?

My goal is to add a button on my excel custom ribbon that loads the data table in the same way as if you clicked Data-> From Other Sources-> From SQL Server.

The object model is so large that it’s hard for me to find the right path.

Thank.

+3
source share
1 answer

Take a look at Microsoft walkthroughs:

For the add-in itself

Walkthrough Create Your First Excel Application Level Add-In

For custom ribbon tab

Walkthrough: Creating a Custom Tab Using XML Ribbon ...

To deploy an add-in

VSTO 2010 Enterprise Deployment

+3
source

More articles:


All Articles