Use Phpexcel to export data to excel in CI

Class Table_export extends Ci_controller { function __construct () { Parent::__construct (); Here you should add some sort of user validation To prevent strangers from pulling your table data } Function index ($table _name) { $this->load->database (); $query = $this->db->query ("select * from ' $table _name ' WHERE del= 1"); $query = mb_convert_encoding ("gb2312", "UTF-8", $query); if (! $query) return false; Starting the Phpexcel Library $this->load->library (' Phpexcel '); $this->load->library (' phpexcel/iofactory '); $objPHPExcel = new Phpexcel (); $objPHPExcel->getproperties ()->settitle ("Export")->setdescription ("none"); $objPHPExcel->setactivesheetindex (0) ->setcellvalue (' A1 ', iconv (' GBK ', ' utf-8 ', ' Chinese Hello ')) ->setcellvalue (' B2 ', ' world! ') ->setcellvalue (' C1 ', ' Hello '); Field names in the first row $fields = $query->list_fields (); $col = 0; foreach ($fields as $field) { $objPHPExcel->getactivesheet ()->setcellvaluebycolumnandrow ($col, 1, $field); $col + +; } Fetching the table data $row = 2; foreach ($query->result () as $data) { $col = 0; foreach ($fields as $field) { $objPHPExcel->getactivesheet ()->setcellvaluebycolumnandrow ($col, $row, $data-$field); $col + +; } $row + +; } $objPHPExcel->setactivesheetindex (0); $objWriter = Iofactory::createwriter ($objPHPExcel, ' Excel5 '); Send headers force users to download files Header (' Content-type:application/vnd.ms-excel '); Header (' content-disposition:attachment;filename= ' products_ '. Date (' DMy '). XLS "'); Header (' cache-control:max-age=0 '); $objWriter->save (' php://output '); } } ?> Copy Code Join the database with a table named products, and then access http://www.yourwebsite.com/table_export/index/products to export the Excel file.

