Complete Excel automation reference?
Posted on 2007-10-19
I'm doing an increasing amount of work with Excel in my Visual Basic .NET programming, and I'm finding the lack of a comprehensive source of information frustrating. I know bits and pieces about how to read and write data in spreadsheets, but it seems to me there ought to be, somewhere, a complete reference to the full Excel Automation object model (all the classes, methods, properties, etc.). I've been looking all over and have come up empty. The best I can find is the information provided by Intellisense while programming, but to allow my software to work with multiple versions of Excel, I'm using late binding, which means that Intellisense more or less disappears. Some information is provided in the online help, but it's neither complete nor systematic, IMHO.
What I'm hoping for is something similar to how classes are described in the online help for VB, with a list of all the classes provided and each one's members. Does it exist anywhere outside a vault in Redmond?