VB.net and excel spreadsheet

[Guest]

--
hello

In VB.net can I import an excel spreadsheet into a formand display it. Also
edit/save cells also on the form.

I want to use code in VB.net form that also effect the spreadsheet.
Can I do this or something like this in VB.net

 

[David Gacek]

take a look at this
http://www.dotnet247.com/247reference/msgs/25/127375.aspx

http://www.codeguru.com/forum/showt...cd05bf27923cd8d3140c682&p=1053045#post1053045

hope that helps

 

[Guest]

This does help.
All of these examples read a spreadsheet into database and you can then
manipulate it. In VB6 you had OLE link and you could put Excel straight onto
a form.

Whats happened to OLE in VB.net Has it gone the way of just read data in a
database and populate a grid?

 

[Cor Ligthert]

John,

Some other links

Office
http://support.microsoft.com/default.aspx?scid=kb;EN-US;311452

http://msdn.microsoft.com/office/

Pia Download
http://www.microsoft.com/downloads/...1e-3060-4f71-a6b4-01feba508e52&displaylang=en

Excel object model
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/ExcelObj.asp

HOW TO: Call a Visual Basic .NET Class Library from Visual Basic for
Applications in Microsoft Office
http://support.microsoft.com/?kbid=317535

I hope this helps a little bit?

Cor

 

[Herfried K. Wagner [MVP]]

In VB.net can I import an excel spreadsheet into a formand display it.
Also
edit/save cells also on the form.

HOWTO: Use the WebBrowser Control to Open an Office Document in Visual Basic
..NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;304643>