Exporting MySQL Data to Excel using PHP - Learn Infinity

Exporting MySQL Data into Excel is a very useful method to keep the data list in a relevant area for offline usage. Exporting data method performs your web application as most user-friendly and improves the user to manage list data in offline. Excel is the greatest construction to Export data in a .xls file and you can easily export database table data into Excel using this method. This post explains to you how to arrange and export our data into Excel file format.

[satyajeetsharma]

i have one problem when i click on export excel it download successful but when i open it come after 15 lines gap. can u solve this

[aminegatou]

it give an error " excel cannot open the file because the file formal or file extension is not valid "