Php Export Excel File

Active1 year, 6 months ago

I'm trying to get my MySQL data to Excel file, but I'm having problems with Excel cells. All my text goes to one cell, I would like to have each row value in separate Excel cell. Here is my code:

Driver hp deskjet 6940 download. Thus, the warranty has been removed from this product.

PHP script for converting data to Excel format and triggering a download. Working example and source code including how to export to Excel from an SQL database. This is my short PHP web development tutorial in which We will talk about how we can use jquery code for export html table data to excel file format by using PHP. In number of web pages in your web application, you want to give one option for generate excel file from your html data table. Excel is the best format to Export data in a file and you can easily export data to Excel using PHP. In this tutorial, we’ll show you how to export data to Excel in PHP. Our simple PHP script lets you implement export data to excel functionality. By one click, the user can export data to Excel and download it in a.xls file.

  • This class is used for exporting the data from a MySql to spreadsheet files in the Excel format. The class executes a given database query and extract the result set data to generate the Excel.
  • Export/Import is very common functionality for web development, some time we need to export all grid data into excel file that time we need below method to export data into excel file. It’s very easy and simple steps in PHP, we need to set header information to force browser to open download window.
  • PHP script for converting data to Excel format and triggering a download. Working example and source code including how to export to Excel from an SQL database.
Puzzled Boy
1,4507 gold badges33 silver badges68 bronze badges
4872 gold badges9 silver badges23 bronze badges

11 Answers

Just Try With The Following :

PHP Part :

I think this may help you to resolve your problem.

John PeterJohn Peter
2,5013 gold badges23 silver badges45 bronze badges
Dileep kuraheDileep kurahe

PHPExcel is your friend. Very easy to use and works like a charm.

Byron Wall
3,6352 gold badges9 silver badges28 bronze badges

If you just want your query data dumped into excel I have to do this frequently and using an html table is a very simple method. I use mysqli for db queries and the following code for exports to excel:


I think you should try with this API

With This

Puzzled BoyPuzzled Boy
1,4507 gold badges33 silver badges68 bronze badges
2,6157 gold badges21 silver badges37 bronze badges
Jek TvJek Tv
A.A NomanA.A Noman
1,7635 gold badges16 silver badges30 bronze badges

try this code


code for excel file


if mysqli version

Feb 11, 2010  147 Picture style for Canon [No email emailan, cendol cendolan, Langsung Download] Nih buat agan agan n sista yang lagi nyari picture style ( aquamrine, emerald etc ) tapi tak tau dimana, ane kasih link nya gratis tis tis tiss ciuzzz. Canon picture style editor download. Canon Picture style adalah salah satu fitur yang ada dalam kamera EOS DSLR yang memungkinkan Read More Free zafizack color action photoshop Series Download Now.


Posts by John Peter and Dileep kurahe helped me to develop what I consider as being a simpler and cleaner solution, just in case anyone else is still looking. (I am not showing any database code because I actually used a $_SESSION variable.)

The above solutions invariably caused an error upon loading in Excel, about the extension not matching the formatting type. And some of these solutions create a spreadsheet with the data across the page in columns where it would be more traditional to have column headings and list the data down the rows. So here is my simple solution:

  1. Change to .csv (which Excel instantly updates to .xls and there is no error upon loading.)
  2. Use the comma as delimiter.
  3. Double quote the Key and Value to escape any commas in the data.
  4. I also prepended column headers to $results so the spreadsheet looked even nicer.

Try the Following Code Please.just only update two values.

Samir LakhaniSamir Lakhani

You can export the data from MySQL to Excel by using this simple code.

complete code here php export to excel

Ehtesham ShamiEhtesham Shami

protected by CommunityAug 3 '17 at 2:48

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged phpmysqlexcelexport or ask your own question.

Active1 year, 8 months ago

This question already has an answer here:

  • PHP generate .xlsx 4 answers
  • Which is the best way to generate excel output in PHP? [closed] 3 answers

I want to export my mysql data to an excel file, I have done it but if I have Greek words they appear with nonsense characters. So I believe I have to add some encoding headers but I didn't found something.

Here is my code:

I don't mind to change the whole code if you got something better to show me.Thanks in advance

27k9 gold badges31 silver badges47 bronze badges
mike vorisis

Php Export To Excel File

mike vorisis
1,3572 gold badges24 silver badges61 bronze badges

marked as duplicate by mario phpDec 17 '17 at 0:07

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer

That's not really how it works. You can't just take some html code for a table, slap a .xls extension onto it and open it in Excel. You need a library to handle this for you. Have a look for example at these two:


Php Export Excel

Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.

Excel Data File

Not the answer you're looking for? Browse other questions tagged phpexport-to-excel or ask your own question.

Comments are closed.