Documentation of Excel Object Model and calling it from VB.NET

[Peter Nolan]

Hi All,
I am about to develop an app in VB.NET (2003) and what it is going to
do is to read a whole series of sheets in an XL spreadsheet and
generate create view statements amongst other things....

What I wanted to do was write the app in vb.net rather than inside the
xlsheet in vba. One major reason being the IDE for .net.

I have already written a similar kind of app with Business Objects VBA
object model.

My questions are:
1. Is there a PDF or similar document of how to access Excel via VBA
calls from VS.net somewhere I can download it? I've searched
microsofts site and didn't find it.

2. Does anyone know where there might be an example application written
in vb.net to read an excel spreadsheet posted on the web? Anything
that would just contain the basics of how to read an excel workbook via
vb.net?

The access I need to excel is really simple, I just want to read
through rows in sheets from top to bottom, nothing complicated. The
complicated bit is all the code I need to generate out the other end.

Any tips/guidance most welcome!!!

Best Regards

Peter Nolan

 

[Tom Ogilvy]

http://search.microsoft.com/search/results.aspx?qu=vstools+office&View=msdn&st=b&c=0&s=1&swc=0

 

[Bob Phillips]

Peter,

There is a new Apress book out by Ty Anderson called Office 2003 Programming
Real World Applications. It covers many aspects of Office but it has a
chapter on a Timesheet system using Excel. You might find this helpful as it
works from start to finish. Read about it at
http://www.apress.com/book/bookDisplay.html?bID=343

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

BTW, should have mentioned that it is Office 2003 based, but as .Net is only
supported since 2002, and the 2003 support is much more extensive, you have
probably already made that assumption.

--

HTH

RP
(remove nothere from the email address if mailing direct)