On the sister site, EVBT, I have a basic tutorial on Excel Automation. The tutorial is written for VB.Net, and I may convert this over to C# one of these days... Although, to be honest, controlling MS Office from C# is a little masochistic anyway; The PIAs are really designed to be called from VB.
That tutorial should get you started, and it has a number of decent links listed in the 2nd post. I think, though, that the most relevant for your needs is probably Ken Getzs treatise:
Ken covers what you need (and then some) quite nicely. If youre still a bit puzzled, come back and be a little more specific and well whip up some examples for you...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.