MySQL to Excel

Posted on 2012-09-21
Medium Priority
Last Modified: 2012-09-26
I want to create an Excel file from a MySQL Table with PHP.

Which is the best PHPExcel template to use?  Is there another example I can follow?
Question by:rgranlund
  • 2
LVL 111

Accepted Solution

Ray Paseur earned 2000 total points
ID: 38424037
I would just write the table out in ".csv" format.  The CSV file type is almost universally associated with Excel.  You can write the file into the server file system and give the client a link to the URL of the CSV file.  A click will open it in Excel, or at least prompt the client to download the file.

Expert Comment

ID: 38425928
If you really need Excel format (xls/xlsx), I recommend phpExcel. It can be downloaded from http://phpexcel.codeplex.com
This library is pretty good, but it can be slow a bit if you work with a big bunch of data.

Author Comment

ID: 38426643
@MrEne In my post I wrote "Which is the best PHPExcel template to use? "

Which is the best template to start with that can create a simple file?

Author Closing Comment

ID: 38437657
I found a great, simple example that explained it really well.  Thanks for pushing me in the correct direction.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s a season to be thankful, and we’re thankful for users like you who engage on site, solve technology problems, and network with others in the industry. What tech are we most thankful for? Keep reading.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Suggested Courses
Course of the Month16 days, 7 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question