O
Oded
Hi,
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_name%"), 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.
Thanks
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_name%"), 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.
Thanks