is it possible to use C# to write functionality within an excel workbook

Question

I have an excel workbook which needs to query data from an HTTP server. Query directly from a remote database isn't an option.

From what I know I can use VB macros to contact the HTTP server and update the cells in the workbook. Is it possible to do this in C#? I don't want to additional burden of deploying an extra application.

Thanks for your help.

You could perhaps set up a local database on a local server and have a C# application keep an up-to-date local cache. — J...
– J..., Commented Jun 30, 2012 at 18:34
@Remou - i don't have a separate C# application. Would preferably want to deploy just the excel file — nutsiepully
– nutsiepully, Commented Jul 1, 2012 at 7:07

lkurylo · Accepted Answer · 2012-06-30 18:23:27Z

3

You can use the VSTO to create a document or application level addin to Excel. Look here http://msdn.microsoft.com/en-us/office/hh128771.aspx

answered Jun 30, 2012 at 18:23

lkurylo

1,65134 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

nutsiepully Over a year ago

the document level customization mentioned in the link might just be exactly what I'm looking for. Thanks a bunch!

lkurylo Over a year ago

if this is exactly what you need, please mark this post as the answer to your question

Community · Accepted Answer · 2017-05-23 12:22:01Z

1

Follow the first couple of repro steps here to create a Visual Studio Tools for Office - Excel Add-In.

Skip the last step about the calender control.

In the Excel AddIn Project > add a Ribbon Bar and Button and you can invoke methods to collect the data via http and refresh the workbook. Everything in VSTO is pretty much the exact same way you would do it in VBA but in C# syntax.

Extend Your VBA Code With VSTO

When it comes to deploying you should use a Setup Project and it will create an MSI. If you have a App.Config file be aware when deploying you need to set the setup project to add a registry key: https://stackoverflow.com/a/10525693/495455

I highly recommend this blog for tips on better VSTO memory management via .Net code: http://jake.ginnivan.net/

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Jun 30, 2012 at 19:09

Jeremy Thompson

66.3k38 gold badges225 silver badges344 bronze badges

Collectives™ on Stack Overflow

is it possible to use C# to write functionality within an excel workbook

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related