CODEWITHSUNDEEP
phphtmlexcel
Mohd Viqar
Mohd Viqar

Reputation: 268

HTML table to excel - PHP

I am creating a report in Table format. This report is displayed on the browser. I want to provide a download report in excel format link so that the report can be available in excel file also. How can I do this

Upvotes: 10

Views: 45853

Answers (3)

Shubham
Shubham

Reputation: 22349

Either you can use CSV functions or PHPExcel Or there is even a better and a simple solution. Just put the Table HTML in a file and save it as XLS file but that might give variety of problems.

Upvotes: 16

Vibin TV
Vibin TV

Reputation: 832

<?php
$file="test.xls";
$test="<table border=1><tr><td>Cell 1</td><td>Cell 2</td></tr></table>";
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$file");
echo $test;
?>

Upvotes: 14

Brennan
Brennan

Reputation: 71

I've used a service called DocRaptor which does awesome html to excel conversion. It also does html to pdf conversion.

If there are better solutions out there as far as retaining the look of your original html and css in Excel, I haven't seen them.

Upvotes: 1

Related Questions