php Excel file export
Phpexcel official website http://phpexcel.codeplex.com/
/** * Export Specific files * Depending on the situation */Public function download () {//1. Gets the corresponding two-dimensional array from the database $alist = Array (...); $list = $alist; $data = Array ();//2. Set the table header name of xls $HEADARR = Array ("Rank", "name", "Phone", "award", "Participation Time"); if (false = = = Empty ($list)) {$i = 0; foreach ($list as $key = + $val) {//assemble the corresponding cell a,b,c,d ... $data [$i] = Array (($i + 1),//a $val [' name '],//b $val [' Tel '],//c $val [' Award '],//d ... ); $i + +; }}else{$data [0] = array (' No related record! '); } $fileName = "Test-excel_"; $this->explodexls ($data, $HEADARR, $fileName); The/** * Tool function handles the XLS file export * @param $data Array () corresponding to the TBODY data * @param $headArr Array () corresponding THEAD data * @param $fileNam E string Specifies the export file name * @return XLS format File Auto Export */Public function exPlodexls ($data, $HEADARR, $fileName) {//note here to the corresponding root directory to find the absolute path $dir = __dir__. ' /.. /.. /.. /.. /public '; Require_once $dir. '/excel/phpexcel.php '; Require_once $dir. '/excel/phpexcel/writer/excel2007.php '; Require_once $dir. '/excel/phpexcel/writer/excel5.php '; Include_once $dir. '/excel/phpexcel/iofactory.php '; if (Empty ($data) | |!is_array ($data)) {die ("data must is a array"); } if (empty ($fileName)) {exit; } $date = Date ("Y_m_d", Time ()); $fileName. = "_{$date}.xls"; Create a new Phpexcel object $objPHPExcel = new Phpexcel (); $objProps = $objPHPExcel->getproperties (); Set table Header $key = Ord ("A"); foreach ($headArr as $v) {$colum = Chr ($key); $objPHPExcel->setactivesheetindex (0)->setcellvalue ($colum. ' 1 ', $v); $key + = 1; } $column = 2; $objActSheet = $objPHPExcel->getactivesheet (); foreach ($data as $key = = $rows) {//Line write $span = Ord ("A"); foreach ($rows as $keyName = + $value) {//column write $j = Chr ($span); $objActSheet->setcellvalue ($j. $column, $value); $span + +; } $column + +; }//$fileName = Iconv ("Utf-8", "gb2312", $fileName); Rename table $objPHPExcel->getactivesheet ()->settitle (' simple '); Set the activity Order index to the first table, so Excel opens this is the first table $objPHPExcel->setactivesheetindex (0); REDIRECT output to a client Web browser (Excel2007) header (' content-type:application/ Vnd.openxmlformats-officedocument.spreadsheetml.sheet '); Header ("content-disposition:attachment; Filename=\ "$fileName \" "); Header (' cache-control:max-age=0 '); $objWriter = Phpexcel_iofactory::createwriter ($objPHPExcel, ' Excel2007 '); $objWriter->save (' php://output '); File download exit via browser; }
The above describes the PHP Excel file Export phpexcel Extension library, including the aspects of the content, I hope that the PHP tutorial interested in a friend helpful.