How to export html table to excel or pdf in php

by

Either you can use CSV functions or PHPExcel

or you can try like below

<?php
$file="demo.xls";
$test="<table  ><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;
?>

The header for .xlsx files is Content-type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

More Related Contents:

  1. Warning: foreach staement
  2. syntax error unexpect something [closed]
  3. Parse error: syntax error, unexpected ‘;’ [closed]
  4. PHP – SSL certificate error: unable to get local issuer certificate
  5. How to use php serialize() and unserialize()
  6. Insert multiple rows with one query MySQL
  7. Dompdf and set different font-family
  8. How to upload large files above 500MB in PHP [duplicate]
  9. Allowed memory size of X bytes exhausted
  10. With “magic quotes” disabled, why does PHP/WordPress continue to auto-escape my POST data?
  11. localhost vs. 127.0.0.1 in mysql_connect()
  12. How to check if a file exists from a url
  13. PHP – include a php file and also send query parameters
  14. How to detect shot angle of photo, and auto rotate for website display like desktop apps do on viewing?
  15. How to use RegexIterator in PHP
  16. Accessing session from TWIG template
  17. sum specific values in a multidimensional array (php)
  18. How to alias the name of a column in Eloquent
  19. How do you make strings “XML safe”?
  20. Unsetting array values in a foreach loop [duplicate]
  21. Laravel – Model Class not found
  22. PHP – Find parent key of array
  23. Back button re-submit form data ($_POST)
  24. PHP exec $PATH variable missing elements
  25. Laravel 3 : Looking for explanation how to use the model
  26. Simple comet example using php and jquery
  27. Find out the error_log’s path
  28. strlen() php function giving the wrong length of unicode characters
  29. count() emitting an E_WARNING
  30. If i use captcha will i be able to stop the spam completely in my blog?

Leave a Comment