Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I have a ASP script query databas

Status
Not open for further replies.

chunbo

Programmer
Jan 9, 2003
16
US

I have a ASP script query database and generate a table. If I use
Response.ContentType = "application/vnd.ms-excel"
the asp response will generate all the output into Excel.
It works for some client computers well, but failed on some other computers.

Why it works only for some client computers?
 
I haven't done much output in excel format but does the clients machine need excel installed in order to view the output? that may be something to check. ---------------------------------------
{ str = "sleep is good for you. sleep gives you the energy you need to function";
ptr = /sleep/gi;Nstr = str.replace(ptr,"coffee");alert(Nstr); }
---------------------------------------
for the best results to your questions: FAQ333-2924

 
found this
There may come a time where you will need to provide data export capabilites to users of your web application. Fortunately this is quite simple to do using the Contenttype property of the Response object. After you've done that, its the same routine as displaying your data in a table, complete with formatting options. TThis script will work for both Netscape and Internet Explorer, however, you will need to either have Excel or the Excel viewer installed ---------------------------------------
{ str = "sleep is good for you. sleep gives you the energy you need to function";
ptr = /sleep/gi;Nstr = str.replace(ptr,"coffee");alert(Nstr); }
---------------------------------------
for the best results to your questions: FAQ333-2924

 
All the testing PCs have MS Excel installed. I guess it's IE's configuration problem, but I don't know how to configure it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top