Ron Borkent
|
Posted: 01/14/2002, 5:37 AM |
|
I tried the tip for exporting to excel en discovered that it worked on one and not on the other computer. After some testing it looks like it only works when the client computer has office 2000 installed. Most of the users at my company have office 97, any ideas how to make the example:
$header_filename = "";
$footer_filename = "";
header("Content-type: application/vnd.ms-excel");
work with office 97?
Ron
|
|
|
Alex Alexapolsky
|
Posted: 01/14/2002, 6:23 AM |
|
How specifically it doesn't work ?
|
|
|
Ron Borkent
|
Posted: 01/14/2002, 6:29 AM |
|
On computers with office 97 it gives a download error and stops. On computers with office 2000 it opens and shows an excel spreadsheet with the intended data.
I tried this on several systems and they all behave the same :
Office 97.... no go
Office 2000 nice spreadsheet
Ron
|
|
|
Ken Hardwick
|
Posted: 01/14/2002, 7:03 AM |
|
I am using the following with ASP and works fine in exporting to Excel 97.
' toExcel Open Event begin
'No Header or Footer needed
Server.ScriptTimeout = 270
sHeaderFileName=""
sFooterFileName=""
'Change HTML header to specify Excel's MIME content type
Response.Contenttype="application/vnd.ms-excel"
' toExcel Open Event end
'===============================
|
|
|
megan_g
|
Posted: 01/14/2002, 8:08 AM |
|
works fine in my office 97 also - ~megan
|
|
|
www.gmsbv.nl
|
Posted: 01/14/2002, 2:01 PM |
|
please visit also www.cellsoft.cc for your excel look-a-like
regards,
marco
www.gmsbv.nl
|
|
|
Brian
|
Posted: 10/08/2002, 12:47 PM |
|
Used the code you provide, but the excel screen comes up blank. Any ideas on where it's breaking?
|
|
|