导出7000条数据耗时20秒。求教,我那里弄的不对了。
function exportExcel($data_array,$array,$filename){$letters_arr=array('1'=>'A','2'=>'B','3'=>'C','4'=>'D','5'=>'E','6'=>'F','7'=>'G','8'=>'H','9'=>'I','10'=>'J','11'=>'K','12'=>'L','13'=>'M','14'=>'N','15'=>'O','16'=>'P','17'=>'Q','18'=>'R','19'=>'S','20'=>'T','21'=>'U','22'=>'V','23'=>'W','24'=>'X','25'=>'Y','26'=>'Z','27'=>'AA','28'=>'AB','29'=>'AC','30'=>'AD','31'=>'AE','32'=>'AF','33'=>'AG','34'=>'AH','35'=>'AI','36'=>'AJ','37'=>'AK','38'=>'AL','39'=>'AM','40'=>'AN','41'=>'AO','42'=>'AP','43'=>'AQ','44'=>'AR','45'=>'AS','46'=>'AT','47'=>'AU','47'=>'AV','49'=>'AW','50'=>'AX','51'=>'AY','52'=>'AZ',);foreach($data_array as $data){$a=array();foreach($array as $k=>$v){$a[]=$data[$k];}$dataArray[]=$a;}Vendor('Zend.Classes.PHPExcel');$objPHPExcel = new PHPExcel();$count=count($array);$count_2=count($dataArray);$count_2=$count_2+3;//首行设置$objPHPExcel->setActiveSheetIndex(0) ->setCellValue('A1',$filename);$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(15);$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);$objPHPExcel->getActiveSheet()->mergeCells('A1:'.$letters_arr[$count].'1');$objPHPExcel->getActiveSheet()->getStyle('A1:'.$letters_arr[$count].'1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//载入数据$objPHPExcel->getActiveSheet()->fromArray($array, NULL, 'A3');$objPHPExcel->getActiveSheet()->fromArray($dataArray, NULL, 'A4');//设置边框$sharedStyle1 = new PHPExcel_Style();$sharedStyle1->applyFromArray(array('borders'=>array('left'=> array('style' => PHPExcel_Style_Border::BORDER_THIN),'right'=>array('style' => PHPExcel_Style_Border::BORDER_THIN),'top'=>array('style' => PHPExcel_Style_Border::BORDER_THIN),'bottom'=>array('style' => PHPExcel_Style_Border::BORDER_THIN))));$objPHPExcel->getActiveSheet()->setSharedStyle($sharedStyle1,'A3:'.$letters_arr[$count].$count_2); //设置表头填充颜色 $objStyleA3 = $objPHPExcel->getActiveSheet()->getStyle('A3:'.$letters_arr[$count].'3');$objStyleA3 = $objStyleA3->getFill(); $objStyleA3->setFillType(PHPExcel_Style_Fill::FILL_SOLID);$objStyleA3->getStartColor()->setARGB('FFFFBB');header('Content-Type: application/vnd.ms-excel');header('Content-Disposition: attachment;filename="'.$filename.'"');header('Cache-Control: max-age=0');$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel5');$objWriter->save('php://output');exit;
回复讨论(解决方案)
1、试试不要用getActiveSheet(),改成:
$objSheet = $objPHPExcel->getSheet(0);
$objSheet->……
2、如果还是比较慢,测试一下不要用fromArray(),改用循环单元格来插入数据
希望能有所帮助。
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:php中文网