Excel in VB.NET form


G

Guest

I need to display Excel data in a Windows form, and I also need to be able to
update the data in cells, and allow users to enter data. I added a reference
to OWC components in my project and I have a form with an AxSpreadsheet
control in it. However, AxSpreadsheet is a Web control and I am running into
stumbling blocks.

Before I buy Alvin Bruney's book on this topic, I would like to know for
certain that I can create a user-editable spreadsheet in a Windows form, and
save and retrieve the data in xml or xls files. I don't want to proceed down
a blind alley when my alternative is simply to use the Excel application
itself.

Thanks.
 
Ad

Advertisements

A

Alvin Bruney [MVP - ASP.NET]

AxSpreadsheet is a Web control
Nope, AxSpreadsheet is a component that lives in a windows forms
environment. It is designed for windows not the web. The fact that it is
part of the office web components is just a matter of packaging. The
components are able to sniff out the environment dynamically to determine
the appropriate run-time ActiveX control to use. If it is a windows
environment, you get AxSpreadsheet1, if it is a web environment you get
Spreadsheet1. The two are different beasts entirely.

Alternatively, you may want to consider using the VSTO.NET for desktop
programming. It is more powerful than the AxSpreadsheet. But, users of your
application must have the framework installed. If you cannot make that
assumption safely, use the OWC instead.
Before I buy Alvin Bruney's book on this topic
Go ahead and buy that book, I hear it is good...

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
 
Ad

Advertisements

G

Guest

Thanks for the info. I'll go ahead full steam with AxSpreadsheet.

James

(P.S. - I ordered the book - couldn't resist the shameless plugs!)


Alvin Bruney said:
AxSpreadsheet is a Web control
Nope, AxSpreadsheet is a component that lives in a windows forms
environment. It is designed for windows not the web. The fact that it is
part of the office web components is just a matter of packaging. The
components are able to sniff out the environment dynamically to determine
the appropriate run-time ActiveX control to use. If it is a windows
environment, you get AxSpreadsheet1, if it is a web environment you get
Spreadsheet1. The two are different beasts entirely.

Alternatively, you may want to consider using the VSTO.NET for desktop
programming. It is more powerful than the AxSpreadsheet. But, users of your
application must have the framework installed. If you cannot make that
assumption safely, use the OWC instead.
Before I buy Alvin Bruney's book on this topic
Go ahead and buy that book, I hear it is good...

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc, Amazon.com etc
mfdatsw1 said:
I need to display Excel data in a Windows form, and I also need to be able
to
update the data in cells, and allow users to enter data. I added a
reference
to OWC components in my project and I have a form with an AxSpreadsheet
control in it. However, AxSpreadsheet is a Web control and I am running
into
stumbling blocks.

Before I buy Alvin Bruney's book on this topic, I would like to know for
certain that I can create a user-editable spreadsheet in a Windows form,
and
save and retrieve the data in xml or xls files. I don't want to proceed
down
a blind alley when my alternative is simply to use the Excel application
itself.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB.NET Forms Wizard 0
windows service in vb.net with a form 0
Startup Event on a VB.NET Form 4
vb.net 1
Dotfuscator and vb.net 4
VB.Net on the network 3
interface vb.net 6
vb.net backspace 0

Top