beginner tutorials for Excel Programming in C#

Question

i'm having 3 years of exp working with excel vba. Now i want to port to excel programming using .net and C#, where can i find learning resources to get up to speed with the equivalent way in C#? thanks

Answer 1

I think this is called Office automation: http://support.microsoft.com/kb/302084

Answer 2

There are several tutorials here and here. By the way, note that you need to run the application as 32bit.

Answer 3

Make sure you get Visual Studio 2008 with the Office Developer Tools included (I think it's from the Pro edition upwards). This does a lot of stuff for you and is definitely worth having.

Answer 4

See this video clip on how to create a C# XLL addin for Excel.

Creating a C# XLL with Visual Studio

You may find it useful. You will need Visual Studio 2005 or 2008 (Express versions are free to download)

XLW, the software demonstrated in the clip can be downloaded from sourceforge and is completely free.

Answer 5

can i program in excel with c# insead vba?how?

Answer 6

Here is an open source tool that makes working with excel more clean and organized:

http://excelwrapperdotnet.codeplex.com/