Reference for using Excel with VB.NET

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

I am having a heck of a time trying to learn how to
manipulate Excel from Visual Basic.NET. Does anyone know
of any good reference articles or books that address this
subject specifically? I found one article on MSDN
called "Understanding the Excel Object Model from a .NET
Developer's Perspective" which is good but I need more
details such as how to open and existing spreadsheet,
copy data from one range of cells on one worksheet to a
range of cells on another worksheet, etc.

Any help would truely be appreciated!
Regards,
Lee
 
Lee said:
I am having a heck of a time trying to learn how to
manipulate Excel from Visual Basic.NET. Does anyone know
of any good reference articles or books that address this
subject specifically? I found one article on MSDN
called "Understanding the Excel Object Model from a .NET
Developer's Perspective" which is good but I need more
details such as how to open and existing spreadsheet,
copy data from one range of cells on one worksheet to a
range of cells on another worksheet, etc.
Click to expand...

I think these questions are related to the Excel VBA object model, not the
VB.NET language. I'd have a look at the Excel VBA docs or turn to the Excel
group.

You can also search the MSFT KB for
visual basic.net excel

I found some links there - don't know if they cover exactly what you need.
One of them:
http://support.microsoft.com/default.aspx?scid=kb;en-us;301982
 
* "Lee said:
I am having a heck of a time trying to learn how to
manipulate Excel from Visual Basic.NET. Does anyone know
of any good reference articles or books that address this
subject specifically? I found one article on MSDN
called "Understanding the Excel Object Model from a .NET
Developer's Perspective" which is good but I need more
details such as how to open and existing spreadsheet,
copy data from one range of cells on one worksheet to a
range of cells on another worksheet, etc.
Click to expand...

There are some HOWTO articles available on the Microsoft support pages:

<http://support.microsoft.com/common...To Articles&LL=kbvbnetSearch&SZ=kbhowtomaster>
 
In addition to Armin's suggestion, here's an article on how to grab data
using .NET (Not com Interop) from excel
http://www.knowdotnet.com/articles/exceldatasource.html
If you are going to do much excel automation, head over to www.j-walk.com
and look at his spreadsheet section. Walkenbach is the man at Excel and has
some great examples. If you get his power programming books he can get you
through just about anything that you might come across.
 
Back
Top