Re: headers-excel file-bad data
- From: blackwaterdev@xxxxxxxxx ("blackwater dev")
- Date: Tue, 31 Jul 2007 13:38:20 -0400
Looks like I have an empty space somewhere...this code is called down in a
class and if I just cut this out and copy into it's own file and call that
file from the browser, it works fine. It is someone getting garbled down in
the class.
On 7/31/07, blackwater dev <blackwaterdev@xxxxxxxxx> wrote:
Hello,
I have an excel file that I am generating. If I copy over the generated
file and then open it in excel, it works fine, if I try to let the user
download it using the headers below, when I then open it excel complains
that it is an unrecognizable format and the info is garbled...any ideas???
Thanks!
header('Pragma: public');
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); //
Date in the past
header('Last-Modified: '.gmdate('D, d M Y H:i:s') . ' GMT');
header('Cache-Control: no-store, no-cache, must-revalidate'); //
HTTP/1.1
header('Cache-Control: pre-check=0, post-check=0, max-age=0'); //
HTTP/1.1
header ("Pragma: no-cache");
header("Expires: 0");
header('Content-Transfer-Encoding: none');
header('Content-Type: application/vnd.ms-excel;'); //
This should work for IE & Opera
header("Content-type: application/x-msexcel"); //
This should work for the rest
header('Content-Disposition: attachment; filename="myfile.xls"');
readfile("/tmp/myfile.xls");
- References:
- headers-excel file-bad data
- From: "blackwater dev"
- headers-excel file-bad data
- Prev by Date: show unread mails in mailbox
- Next by Date: Re: [PHP] Job Opportunity: PHP Developer
- Previous by thread: headers-excel file-bad data
- Next by thread: show unread mails in mailbox
- Index(es):
Relevant Pages
|