Excel in .Net tutorials

Diesel

Well-known member
Joined
Aug 18, 2003
Messages
662
Anyone have any code or tutorials that shows how to create, fill and write an Excel worksheet to a file?
 
Hey Diesel,

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.

The tutorial is here:

Automating Office Programs with VB.Net / COM Interop

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:

Understanding the Excel Object Model from a .NET Developers Perspective

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...

-- Mike
 
Last edited by a moderator:
Back
Top