導出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中文網

總結

以上是生活随笔為你收集整理的php到处excel慢,phpexcel导出数据耗时，求教的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。