Wrox Programmer Forums
|
Classic ASP Components Discussions specific to components in ASP 3.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Components section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 14th, 2004, 04:13 AM
Authorized User
 
Join Date: Oct 2003
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default Displaying output in Excel via ASP

Hi

I've managed to get an Excel sheet opened up via an ASP page with user specific data in it. The problem is, rather than having it opened up and displayed in a new window i need the user to be able to download the file with all the formatting (ie have all the headings as bold, gridlines enables etc) already done to it.

Here's the code that makes the content of the asp page into an Excel sheet:

Response.ContentType = "application/vnd.ms-excel"

Any idea how i can go about doing this?

Thanks for your help in advance.
 
Old April 14th, 2004, 04:21 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 344
Thanks: 0
Thanked 1 Time in 1 Post
Default

check out http://www.greggriffiths.org/webdev/both/excel/ which covers this.
 
Old April 19th, 2004, 05:02 AM
Authorized User
 
Join Date: Oct 2003
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Cheers for the website.
 
Old April 22nd, 2004, 11:35 AM
Authorized User
 
Join Date: Apr 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to ³Â×÷
Default

Äܲ»ÄÜ˵ÇåÒ»µã°¡£¡

 
Old May 3rd, 2004, 07:37 AM
Registered User
 
Join Date: Apr 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Great website!





Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP to Excel - excel output formatting issue mat41 Classic ASP Professional 0 August 13th, 2006 06:41 AM
matching the output and displaying the data ct Excel VBA 0 April 13th, 2006 04:01 AM
Output to Excel rgerald SQL Server 2000 9 July 7th, 2005 09:42 AM
About output data to excel momowu0701 Beginning VB 6 0 March 1st, 2005 09:31 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.