Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reference documentation for automating Excel form .NET

Status
Not open for further replies.

dpdg

Programmer
May 23, 2005
148
US
I've been having to do a lot of automation of Excel spreadsheets from .NET and I get information from about everywhere I can find it. There doesn't seem to be any complete documentation on the subject. About the best I have been able to find is on Microsoft's site. But there are still a lot of other things that I need to be able to figure out.

Does anyone know of a good complete reference book or somewhere on line that I could find some good documentation on this?

Someone said that VBA is good for that, but is it the same in dot net?
 
To automated Excel just add a reference to the primary interop assemblies (comes with Office Tools for .NET), then make call pretty much like you would under COM.

So, to learn how to automate Excel in .NET, pick up any Office VBA book. The actual syntax of the code you write will be in VB.NET, but all the method names will be identical.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top