468,119 Members | 2,088 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,119 developers. It's quick & easy.

VB.net and excel spreadsheet


--
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
Nov 21 '05 #1
4 6224
take a look at this
http://www.dotnet247.com/247referenc...25/127375.aspx

http://www.codeguru.com/forum/showth...45#post1053045

hope that helps

"john andrew" <jo********@discussions.microsoft.com> wrote in message
news:E0**********************************@microsof t.com...

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

Nov 21 '05 #2
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?

"David Gacek" wrote:
take a look at this
http://www.dotnet247.com/247referenc...25/127375.aspx

http://www.codeguru.com/forum/showth...45#post1053045

hope that helps

"john andrew" <jo********@discussions.microsoft.com> wrote in message
news:E0**********************************@microsof t.com...

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


Nov 21 '05 #3
John,

Some other links

Office
http://support.microsoft.com/default...b;EN-US;311452

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

Pia Download
http://www.microsoft.com/downloads/d...displaylang=en

Excel object model
http://msdn.microsoft.com/library/de...l/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

"john andrew" <jo********@discussions.microsoft.com>
..
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?

"David Gacek" wrote:
take a look at this
http://www.dotnet247.com/247referenc...25/127375.aspx

http://www.codeguru.com/forum/showth...45#post1053045

hope that helps

"john andrew" <jo********@discussions.microsoft.com> wrote in message
news:E0**********************************@microsof t.com...
>
> --
> 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


Nov 21 '05 #4
"john andrew" <jo********@discussions.microsoft.com> schrieb:
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>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Phil Powell | last post: by
5 posts views Thread by Scott M. Lyon | last post: by
3 posts views Thread by S_K | last post: by
14 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.