Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 10th, 2005, 12:13 PM
Registered User
Join Date: Apr 2004
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Export ASP reports to Excel

Hi everyone,

I have been trying to export ASP reports to Excel format.
So I put this line on the top of my ASP page:
************************************************** *
Response.ContentType = "application/vnd.ms-excel"
************************************************** *
It did save my report to Excel file but it has no records in that excel file while it shows 50 records on my ASP report.

Here is my work environment:

I have 3 asp pages (search.asp, search_response.asp, search_excel_response).

On my search.asp page, I allow users to select the customers that they want to search for. As soon as they select a customer and click the SUBMIT button, it will take the users to the search_results.asp page and from there it will display a list of records based on the user's selection.

On this search_response.asp page, I put a button that links to search_excel_response.asp. This page looks exactly like the search_response.asp page except I added this line (Response.ContentType = "application/vnd.ms-excel") to the top of my page and hope that when the user click the button on Search_response.asp page, it would save this file to excel format.

Well, the truth is, it did save the file to excel format but it doesn't include any records in that excel file (I know for sure there are 50 records somewhere).

I did search goole.com for this problem but so far, I haven't found any solution. If someone has experienced this problem, please share.

Thanks for any input you might provide.

Reply With Quote
  #2 (permalink)  
Old November 24th, 2005, 11:53 PM
Registered User
Join Date: Nov 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

Hi there,
I am experiencing the same problem..:(
did you get any solution??
Could you pls share with me

Its very urgent!!

Reply With Quote
  #3 (permalink)  
Old November 30th, 2005, 07:07 PM
Friend of Wrox
Join Date: Jun 2003
Location: High Wycombe, UK, United Kingdom.
Posts: 344
Thanks: 0
Thanked 1 Time in 1 Post

can you post some code or a sample output file ? there are several samples at http://www.greggriffiths.org/webdev/both/excel/ which could help.
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Export to excel from ASP jayanp Classic ASP Basics 4 July 31st, 2007 03:01 PM
Export Crystal Reports' report to Excel ONLY DATA peter2004 Crystal Reports 0 January 6th, 2007 02:30 PM
How to export xml to excel using ASP porsrari XML 1 September 5th, 2003 06:26 AM
How to export XML to Excel using ASP? porsrari Classic ASP Basics 2 September 4th, 2003 09:44 AM
Use ASP/SQL to export to Excel sankar Classic ASP Basics 10 July 18th, 2003 04:04 AM

All times are GMT -4. The time now is 10:10 AM.

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