create excel file from HTML table using jQuery or PHP

Question

I have a HTML table on my PHP page,that I want to export to excel file and available this file for user download on a button click . How can I do this using jQuery or PHP ? .Any code examples to demo. this would be great

There is another question and answers will be helpfull for you [HERE][1] [1]: stackoverflow.com/questions/18672680/… — metin
– metin, Commented Mar 27, 2014 at 5:44

ShankarSangoli · Accepted Answer · 2011-08-30 12:03:49Z

1

You have to post the html markup of the table you have on the page or create the same markup on the server side and then use the below code to export it into excel format.

<?php
$file="test.xls";
$test="TheTableMarkupWillGoHere";
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$file");
echo $test;
?>

edited Aug 30, 2011 at 12:03

answered Aug 30, 2011 at 11:54

ShankarSangoli

69.9k13 gold badges96 silver badges124 bronze badges

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

Collectives™ on Stack Overflow

create excel file from HTML table using jQuery or PHP

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related