Geek Answers Handbook

How to connect C # to excel API

Is it possible to connect to the same excel libraries that are used in VBA, but use C # instead to be able to use all the features of the .Net framework? I would like to recreate some automated VBA applications in C # at some point in the near future in the .NET infrastructure in order to expand my capabilities and increase their speed, but I'm not sure how to do this.

+5
source share
1 answer

I believe that you can directly reference the DLL file that is referenced by default when using VBA. It's called the "Microsoft Excel Object Library", and you add it as a link just like you would with any other namespace in C #

Here is a great link to use http://www.codeproject.com/Articles/5123/Opening-and-Navigating-Excel-with-C

+1
source

More articles:


All Articles