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 October 2nd, 2007, 11:08 AM
Registered User
 
Join Date: Oct 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default "application/vnd.ms-excel" problem

Hi,

My company has an Web-based administration centre with which we can generate a table of recent sales, and export to Excel with a button click. I recently redesigned this admin centre: now, whenever I try to export the sales result table, all I get is a white screen in Excel (ie, not even the lines separating boxes) and the page header. No other content makes it over.

There hasn't really been any change in how the spreadsheet is generated: I use...

    Response.ContentType = "application/vnd.ms-excel"
    Response.AddHeader "Content-Disposition", "attachment; filename=RecentSales.xls"

Currently, each page has a header with Javascript drop-down menus, followed by a site search form: the recent sales page has a form with which you specify the terms you want to search for in terms of sales. I'm wondering if the presence of either the drop-down menu Javascript or the two forms is messing things up.

Any ideas?

AK

 
Old January 15th, 2008, 01:09 PM
Registered User
 
Join Date: Jan 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to crownbc
Default

hi, did you get a solution to this? i have had the same problem for a while and can not fix it..

thanks,

Paul






Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem in opening excel file in MS Excel 2000 kallol Visual C++ 0 November 16th, 2007 05:48 AM
When I used "application/vnd.ms-excel" to export t miaomiaoga Classic ASP Basics 1 October 20th, 2007 04:00 AM
application/vnd.ms-excel Help! drumph Classic ASP Components 3 May 31st, 2007 06:02 AM
When I used "application/vnd.ms-excel" to export t miaomiaoga Classic ASP Databases 0 January 28th, 2005 04:12 PM
Using MS Excel in application justshahid VS.NET 2002/2003 2 January 13th, 2005 11:56 AM





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