0

I want to get all the data from mysql table and save it in Excel format using SimpleXLSX library and let the user download that excel format. I have use that library before for importing data from excel file but now i want it for exporting from mysql database to Excel Format.

user3653474
  • 3,393
  • 6
  • 49
  • 135
  • What have you tried so far? – Aksen P Jun 10 '20 at 14:04
  • I have found this link where we can save sql data in excel file, https://stackoverflow.com/questions/15699301/export-mysql-data-to-excel-in-php but i want to know can i use SimpleXLSX Library for that because i have used it before in the same project to import data. – user3653474 Jun 10 '20 at 14:10

1 Answers1

0

If you're using only SimpleXLSX.php - it's impossible. example source

If you're using additional files like SimpleXLSXStyle.php, SimpleXLSXWorkbook.php, SimpleXLSXWorksheet.php - you could save it in some directory and then retrieve it(create, save into temp dir, retrieve, delete from temp dir). example source

The final answer it's possible or not would be done after researching of the SimpleXLSX library files in your project.

Aksen P
  • 4,564
  • 3
  • 14
  • 27