"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
|