ASP & Excel
I'm trying to export an ASP based report to Excel while preserving its
display properties. I've added:
Response.ContentType="application/vnd.ms-excel", and it works fine for
several clients. For other clients it displays an emptry excel sheet.
I'm not sure, but i think it has something to do with the excel version
installed on clients - empty sheets were displayed for Excel 2000 clients
while clients running Excel 2002 displayed the report correctly.
If I add: Response.AddHeader("attachment","file_name=%file_n ame%"), all
clients display the data correctly but the styles are lost.
If anyone knows of a solution other than reformatting the report for excel,
it will be very helpful.
|All times are GMT. The time now is 03:32 AM.|
Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.