What's currently the best way to extend Excel using C#?

Posted by user169867 on Stack Overflow See other posts from Stack Overflow or by user169867
Published on 2010-05-07T20:58:23Z Indexed on 2010/05/07 21:08 UTC
Read the original article Hit count: 244

Filed under:

ms-office

|

office-interop

|

.NET

|

c#

|

vsto

I have the professional versions of VS2008 & VS2010.

I wish to add a couple buttons to a toolbar in Excel. When they are clicked I'd like to be able to open a form (either WinForms or WPF is fine) collect a few values from the user in the form and then take that data + read cell values from the current worksheet to perform some database operations.

What's currently the best way to do this using C#? I'd greatly appreciate a pointer to any examples / tutorials. My understanding is that VS2010 has improved the process alot but I may have to deal w/ Excel 2003 which I don't think it supports.

I get confused between Visual Studio 2008s Extensibility->Shared Addin template and other Office Addin templates I've seen. I'm not sure when which type of solution is appropriate.

I'm new to Office development so I'd really appreciate any help to get me going on the right track.

Thanks much.

© Stack Overflow or respective owner

Related posts about ms-office

How to change ms office 2010 beta key

as seen on Super User - Search for 'Super User'
I have installed office 2010, using a key that I found on forums on the internet. It said it was used to many times already. But when I try to use the mak key that is on my account, it says that it is invalid. How do I change the key, if a key is still installed and is available for 30 days. >>> More
Creating the Previews of MS Office Files like word excel and PPT in cocoa

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi How can I create the preview image for MS Office files like word, excel , power point in cocoa. Can anyone suggest me on this like how to handle those file?. I tried using the Bitmap representation of the .doc files.It dint work.. Which API i can use?.. thank you.. >>> More
=rand(100,60) - MSOffice Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
Oho ! Have you tried this one ?? Very simple office utility question. The question is something like this. Open Microsoft word ( 2003 or 2007 ) whatever you use. ( Let me clarify that - I am not here for any kind of advertisement of Micro soft - I want to solution to my Query ) After opening… >>> More
User (MS-Office) generated content - how?

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I allow users to share Microsoft Office generated content on an ASP.Net site? For example usage, imagine a site similar to StackOverflow. George, writing a question, uses Word, Excel or OneNote to create content, and then inserts the content into the question area (probably copying it into… >>> More
How to avoid the configuring ms office dialog box

as seen on Super User - Search for 'Super User'
I always see the configuring ms office with a an endless progress bar, 2 or more weeks after I installed ms office(2000, 2003, 2010 beta). I'm not exactly sure what it is called but it is trying to configure ms office.Or maybe repairing the installation. And it sucks because when I need to access… >>> More

Related posts about office-interop

Merge Word Documents (Office Interop & .NET), Keeping Formatting

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having some difficulty merging multiple word documents together using Microsoft Office Interop Assemblies (Office 2007) and ASP.NET 3.5. I'm able to merge the documents, but some of my formatting is missing (namely the fonts and images). My current merge code is shown below. private void CombineDocuments()… >>> More
Microsoft.Office.Interop.Word documentation

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to use the Microsoft.Office.Interop.Word namespace to extract if a Word document contains macros, and which ones. The MSDN documentation for this namespace doesn't give much information compared to the documentation on other .Net classes. Where can I get more informations about this namespaces… >>> More
Microsoft.Office.Interop.Excel.ListObject vs Microsoft.Office.Tools.Excel.ListObject

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to access the Selected Event of all the listobjects in all the worksheets of my workbook but when I access worksheet.listobject, that object apparently belongs to Microsoft.Office.Interop.Excel.ListObject and so doesn't have any events where as the table list object belongs to Microsoft.Office… >>> More
Using Microsoft.Office.Interop to save created file with C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the this code that will create excel file and work sheet then insert same values. The problem I'm facing that I'm not able to save the file with name giving ten colse it. I used SaveAs but did not work: wb.SaveAs(@"C:\mymytest.xlsx", missing, missing, missing, missing, missing, XlSaveAsAccessMode… >>> More
Worksheet.Unprotect - Office Interop - Difference between 2003 and 2007

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a .NET winforms app that automates Excel and checks for a worksheet password. The requirements are to be able to detect 1) that the protection is turned off 2) that the password is removed (protected but there is no password) 3) that the password matches the correct password from a database To… >>> More