excel

Exporting your MySQL table data with PHPExcel + CodeIgniter

Posted by Danny Herran on Mar 8, 2011 in Backend | 29 comments

PHPExcel + CodeIgniter Most of the time my clients need to download data from their database tables. Exporting to CSV is a pain in the rear for users and it leads to confusion (you know the colon and semicolon stuff). Today, I decided to make a very small controller that is portable and efficient for exporting full MySQL tables to Excel 2003 using PHPExcel and CodeIgniter.