|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: application/vnd.ms-excel |
|
From: |
J. Paul Schmidt |
|
Date: |
5/22/2001 2:44:06 AM |
|
IP: |
205.188.199.34 |
I imagine it could take awhile to format 2,000 Excel rows. Perhaps check these Excel-related articles out:
Output To MSExcel
http://www.codeave.com/asp/code.asp?u_log=40
"The only difference between the code below and an .asp page that would output to the browser is <%Response.ContentType = "application/vnd.ms-excel"%> which opens Excel within the browser window and providing that MSExcel97 or better is installed on the PC it will output to an excel spreadsheet."
ASP Tutorial: Dynamic Excel Reports
http://www.aspalliance.com/stevesmith/tutorials/exceltutorial.asp
"Lastly, the generated reports can be complete with Excel formulas, which allows intensive calculations to be moved to the client side. This method only works with Excel 97 or later."
Exporting ASP Reports to Excel Format by By David Schultz
http://www.asptoday.com/articles/19991103.htm
3 methods:
ContentType - has limitations.
Comma Separated Values (CSV) - good directions here
Microsoft Excel object - requires Excel on the server and that would be a hog if used each time.
Updating Excel From the Web by Bill Jeffries - 10/21/1999
http://www.15seconds.com/issue/991021.htm
Best regards,
-Paul
J. Paul Schmidt, MBA
Databases on the Web
http://www.Bullschmidt.com |
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
