How to extract all data from sql table and save it in excel file in codeigniter using SimpleXLSX

Question

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.

I have found this link where we can save sql data in excel file, stackoverflow.com/questions/15699301/… 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
– user3653474, Commented Jun 10, 2020 at 14:10

Aksen P · Accepted Answer · 2020-06-10 14:43:47Z

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.

edited Jun 10, 2020 at 14:43

answered Jun 10, 2020 at 14:36

Aksen P

4,6153 gold badges16 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to extract all data from sql table and save it in excel file in codeigniter using SimpleXLSX

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related