How to import Excel documents: automation?

[Jo]

I need to import an Excel document, and it seems automation is the best
way to go, but the last time I tried that, I was working with a million
classes, and no documentation explaining how to use them. Is there a
book or some other resource that can show me how to do this? If
automation is not the solution, then what is? A commercial library?
Maybe I should point out that I'm not intending to use automation
to use any of the GUI controls. I just want to import the data in the
document, but not display it.

 

[Ajay Kalra]

This article on Office automation in VC++ will be good help:

http://support.microsoft.com/defaul...rt/kb/articles/Q196/7/76.ASP&NoWebContent=1,1

 

[Jo]

This article on Office automation in VC++ will be good help:

http://support.microsoft.com/defaul...rt/kb/articles/Q196/7/76.ASP&NoWebContent=1,1

If it's out of MSDN and older than about 7 or 8 months, then I've
probably looked at it already. I see that article's been revised since
then, but I have the feeling that I'd have to find an article with a
fundamentally different approach to documenting automation. All I
remember about that is whatever I found back then didn't give me
everything I needed. I could give it another go w/this one I guess.
What I didn't make use of were the recommended books. There are
several mentioned in: http://support.microsoft.com/kb/152023/EN-US/.
Which of these would be worthwhile for the task I'm performing? Do I
need COM for that?

 

[Ajay Kalra]

Do I need COM for that?

COM is the technology which allows exposing object model for
Automation.

Keep in mind that life is much simpler(for using automation) if you use
VB or .Net.

 

[Jo]

COM is the technology which allows exposing object model for
Automation.

Keep in mind that life is much simpler(for using automation) if you use
VB or .Net.

Is it? Well, VB is out of the question, but I guess I could use
..NET, for the first time ever. It seems that not buying a book is also
out of the question. Thanks.