-3

How can I use php sql to export to Excel and NOT csv/tsv?

I have googled for it for a while but am only finding multiple results on exporting to csv.

Even if you just point me to the name of the method I can google it from there.

Thanks

Lyndon Penson
  • 65
  • 1
  • 8
  • Can you please be more specific? i am unable to understand your requirement. – Davinder Kumar May 03 '17 at 06:56
  • 1
    http://stackoverflow.com/questions/15699301/export-mysql-data-to-excel-in-php is like the first Google search result. – Satwik Nadkarny May 03 '17 at 07:16
  • 1
    Possible duplicate of [What is the best way to create XLS file in PHP](http://stackoverflow.com/questions/3133357/what-is-the-best-way-to-create-xls-file-in-php) – Picard May 03 '17 at 07:51

1 Answers1

0

You can use a lib like phpExcel or Spout to create (and read) excel files.

  • phpExcel : lots of options, but slow
  • spout : less options, but much faster than phpExcel
N.P.
  • 181
  • 2
  • 12