excel spread sheet in ASP page??

[shvonne]

is it possible for me to put my data in excel spreadsheet through visual basic and publish it in ASP page or DHTML page???

^o^

[Lothar Haensler]

there are several ways to do this.
1. use OFfice 2000 Web components. All Office 2000 apps come with ActiveX components that let you publish Office-documents on the web - requires O2k license for the user.

2. you could use an anchor that refers to an Excel file as in <a href="...xls">...</a> and IE will download the file and display it in Excel if Excel is installed.

[shvonne]

thanks lothar for the info..

but what i mean is that i want to query my database than put the result in the excel spread sheet and generate graph using the excel capablity. after that, if user make a request from asp page, i will send the result as excel spead sheet to he/she.. do u think it is possible to do that?

[Lothar Haensler]

although I still don't understand, what you are really trying to do, my answer is YES, I think you can do it in an ASP :-)
e.g. you could do a response.redirect to an XLS file that you have either copied to your web server or created via automation from your ASP.

[shvonne]

thanks a lot lothar for helping me.... actually i dunno how to explain it to u also cause it's quite complicated.... it's a long long story over here... ^o^...

cheers!!!

shvonne

[Iulian Iuga]

Not isn't possible to put an excel spreadsheet through visual basic and publish it in ASP page. You have only possibility: create an ActiveX or a java applet and including this object in your page using the <OBLECT> tag. This object is necessary have excel spreadsheet proprieties.

[Lothar Haensler]

please check this excellent sample I have just found on http://www.swynk.com/friends/franke/
It shows how to create excel sheets in an ASP!

[shvonne]

thanks a lot lothar... =)

^o^...