Php export table to excel

Question

I have this code that exports a html table to excel.

print $obj->methodThatReturnTable();

header("Content-type: application/vnd.ms-excel");
header("Content-type: application/force-download");
header("Content-Disposition: attachment; filename=$fileName");
header("Pragma: no-cache");

It works fine for tables with a few rows, but now I have created a table with almost 1000 rows (8 columns) and instead of the download be forced, the table is showed in the browser.

What could be happening?

You must send headers before print your excel content with $obj->methodThatReturnTable() — Anas
– Anas, Commented Oct 22, 2014 at 15:33
Your "Content-Type" header is duplicated, is that normal ? Try : header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=$fileName"); header("Pragma: no-cache"); $obj->methodThatReturnTable(); Can you post the content of your methodThatReturnTable function ? — Anas
– Anas, Commented Oct 22, 2014 at 15:41
I guess it's normal, because it works for table with a few rows. The content of the method just return a table in html. It's too many lines to be posted, won't help. I THINK the problem is the size of the table, but I can't find anything to solve this problem... — gbvisconti
– gbvisconti, Commented Oct 22, 2014 at 15:47
I know, but it's not the right way to do this. It's better to start things properly. The lib i recommanded you will facilate your job when you should use xls specific features like "Formula" — Anas
– Anas, Commented Oct 22, 2014 at 15:54

Sree · Accepted Answer · 2015-05-15 17:58:07Z

3

Please check PHP: Exporting Data to Excel. It may help you.

edited May 15, 2015 at 17:58

user4560413

answered Oct 22, 2014 at 17:45

Sree

1,5293 gold badges16 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

Php export table to excel

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related