+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: MySQL to Excel??? how can i export data from MySQL to excel in codeIgniter? (/showthread.php?tid=37986)
MySQL to Excel??? how can i export data from MySQL to excel in codeIgniter? - El Forum - 01-26-2011
[eluser]Unknown[/eluser]
hello everyone:
There have a table "userInfo"(two fields,"username","address") in MySQL database. I want to
export data from the userInfo table into a excel file and can download it in website(every record has its own link,click the link ,popup a dialog,we can download the content of that record),how can i do that? i am a fresh in world of codeIgniter.
MySQL to Excel??? how can i export data from MySQL to excel in codeIgniter? - El Forum - 01-26-2011
[eluser]Kindari[/eluser]
Export it as a csv file, which excel can open. See here:
http://ellislab.com/codeigniter/user-guide/database/utilities.html#csv
MySQL to Excel??? how can i export data from MySQL to excel in codeIgniter? - El Forum - 01-27-2011
[eluser]daparky[/eluser]
Or you could do it in PHPMyAdmin?
MySQL to Excel??? how can i export data from MySQL to excel in codeIgniter? - El Forum - 03-07-2011
[eluser]Unknown[/eluser]
About your question, I want to recommand you an article which is published on Codeproject.
It shows how to export data to excel with a small tool. Also, it displays the data source.
You can read the article on http://www.codeproject.com/KB/cs/Excel_PDF_Word_ExportWiz.aspx
Hope helpful!
MySQL to Excel??? how can i export data from MySQL to excel in codeIgniter? - El Forum - 03-09-2011
[eluser]Brad K Morse[/eluser]
Try this http://codeigniter.com/wiki/Excel_Plugin/