PHP - excel file download

Question

I download files from server but excel or word files are corrupted after download. Pdfs, jpgs etc. are ok.

ob_clean();
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Cache-Control: private",false);
header("Content-Type: ").$att->getType();
header("Content-Disposition: attachment; filename=" . basename($att->getName()));  
header("Content-Transfer-Encoding: binary");
header("Content-Description: File Transfer");
readfile($path);

Content type for excel I have - application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Amin Maleki · Accepted Answer · 2020-12-27 16:39:16Z

2

Just Change

header("Content-Type: ").$att->getType();

to

header("Content-Type: ".$att->getType());

You send file with null Content-Type...

answered Dec 27, 2020 at 16:39

Amin Maleki

1662 gold badges4 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

RCH Over a year ago

you are right but I also tried header("Content-Type: application/octet-stream"); or header("Content-Type: application/vnd.ms-excel"); or header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") with same result

Ken Lee · Accepted Answer · 2020-12-27 16:10:20Z

1

For excel and word, try changing

header("Content-Type: ").$att->getType();

to

header("Content-Type: application/octet-stream");

or, for excel

header("Content-Type: application/vnd.ms-excel");

or, for word

header("Content-Type: application/msword");

edited Dec 27, 2020 at 16:10

answered Dec 27, 2020 at 16:00

Ken Lee

8,5203 gold badges14 silver badges34 bronze badges

2 Comments

RCH Over a year ago

No, I had that it before but It wasn't working

Ken Lee Over a year ago

For png and zip, you should use Content-type: image/png and Content-Type: application/zip respectively but in case of problem (say in your case), please try octet-stream or Content-Type: application/vnd.ms-excel or application/msword (please try my revised answer)

RCH · Accepted Answer · 2020-12-27 17:40:55Z

0

Problem was different... I've just had in my php file new line after ?> Thank Amin and Ken for help

answered Dec 27, 2020 at 17:40

RCH

1,3091 gold badge11 silver badges23 bronze badges

1 Comment

Ken Lee Over a year ago

Nice to know that you have fixed the problem. Have a nice day.

Collectives™ on Stack Overflow

PHP - excel file download

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related