PHP Excel file export phpexcel Extension Library

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; }

PHP Excel file export phpexcel Extension Library