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^
Printable View
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^
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.
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?
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.
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
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.
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!
thanks a lot lothar... =)
^o^...