/* +---------------------------------------------------------------------- | Introduce: Data export Excel +----------------------------------------------------------------------| @param $config Header, file name and other related configuration information +----------------------------------------------------------------------| @param $data The result set to be exported by array +----------------------------------------------------------------------| author:liwuming +----------------------------------------------------------------------*/function exportexcel ($ Config, $data) {include './phpexcel/phpexcel.phpexcel '; $objPHPExcel = new Phpexcel (); $objWriter = Phpexcel_iofactory:: Createwriter ($objPHPExcel, ' Excel5 '); $column = 2;foreach ($data as $key = + $rows) {//Line write $span = Ord ("A"); $i = 0;foreach ( $rows as $keyName = + $value) {//column write $j = Chr ($span); $objPHPExcel->getactivesheet ()->setcellvalue ($j. $column, $ Value), if ($config [' Center '] [$i]) {$objPHPExcel->getactivesheet ()->getstyle ($j. $column)->getalignment () ->sethorizontal (\phpexcel_styLe_alignment::horizontal_center);} else{$objPHPExcel->getactivesheet ()->getstyle ($j. $column)->getalignment ()->sethorizontal (\phpexcel _style_alignment::horizontal_left);} $span + +; $i + +;} $column + +;} Set sheet name if (!empty ($config [' title ']) {$objPHPExcel->getactivesheet ()->settitle ($config [' title ']); }//Set default row Height $height =!empty ($config [' height '])? $config [' Height ']:30; $objPHPExcel->getactivesheet () Getdefaultrowdimension ()->setrowheight ($height);//Set Default font Size $objphpexcel->getactivesheet (), Getdefaultstyle (' a1:z1 ')->getfont ()->setsize (14); $objPHPExcel->getactivesheet ()->getstyle (' A1:z1 ')->getfont ()->setbold (true); Set table Header $key = Ord ("A"); Returns the ASCII code value of the character $i = 0;foreach ($config [' header '] as $v) {$colum = Chr ($key); $objPHPExcel->getactivesheet () Setcellvalue ($colum. ' 1 ', $v), $objPHPExcel->getactivesheet ()->getcolumndimension ($colum)->setwidth ($config [' width '] [$i]); $objPHPExcel->getactivesheet ()->getstyle ($colum. ' 1 ')->getalignmeNT ()->sethorizontal (\phpexcel_style_alignment::horizontal_center); $key +=1; $i + +;} Set the file name if ($config [' name '] = = ' Time ' | | $config [' name '] = = ') {$date = date ("Y_m_d", Time ()), $fileName. = "{$date}.xls";} else{$fileName. = "{$config [' name ']}.xls";} $fileName = Iconv ("gb2312", "Utf-8", $fileName); Iconv file Encoding Conversion header ("Pragma:public"); Header ("expires:0"); Header ("Cache-control:must-revalidate, Post-check=0, p Re-check=0 "); Header (" Content-type:application/force-download "); header (" CONTENT-TYPE:APPLICATION/VND.MS-EXECL; Charset=utf-8 "); Header (" Content-type:application/octet-stream "); Header (" Content-type:application/download "); Header (' Content-disposition:attachment;filename= '. $fileName. ' '); $objWriter->save (' php://output '); Exit ();}
Export Report Excel