做php導(dǎo)出，需要循環(huán)輸出數(shù)據(jù)到execl中，一開始寫了一個，覺得時間有點長，就縮短了下，發(fā)現(xiàn)時間還變多了，求教這是為什么啊？謝謝了先。原先的代碼片段：//歸總每個一級分類下的二級分類foreach($first_cate_arrayas$fkey=>$fvalue){foreach($cateas$ck=>$cv){if($cv['parentid']==$fvalue['id']){$first_cate_array[$fkey]['second_cate'][]=$cv;}}//獲得每個一級分類下二級分類的數(shù)目$second_count=count($first_cate_array[$fkey]['second_cate']);$first_cate_array[$fkey]['second_count']=$second_count==0?1:$second_count;}/*************************************************************************/foreach($first_cate_arrayas$fk=>$fv){//一級目錄起始行數(shù)if($fk==0){$stapos=$num;$en_stapos=$stapos+$cate_count;}else{$stapos=$stapos+$first_cate_array[$fk-1]['second_count'];$en_stapos=$stapos+$cate_count;}foreach($fv['second_cate']as$sck=>$scv){//二級目錄起始行數(shù)$stapos1=$stapos+$sck;$en_stapos1=$en_stapos+$sck;foreach($scv['pro']as$spk=>$spv){$str1=70+$spk*3;$str1=chr($str1);$str2=71+$spk*3;$str2=chr($str2);$str3=72+$spk*3;$str3=chr($str3);//中文$collect=$spv['name'].'（'.$spv['description'].'）';$objActSheet->setCellValue($str1.$stapos1,$collect);$objActSheet->setCellValue($str2.$stapos1,$spv['name']);$objActSheet->setCellValue($str3.$stapos1,$spv['description']);//英文$en_collect=$spv['en_name'].'('.$spv['en_description'].')';$objActSheet->setCellValue($str1.$en_stapos1,$en_collect);$objActSheet->setCellValue($str2.$en_stapos1,$spv['en_name']);$objActSheet->setCellValue($str3.$en_stapos1,$spv['en_description']);}//中文$objActSheet->setCellValue('E'.$stapos1,$scv['category']);//英文$objActSheet->setCellValue('E'.$en_stapos1,$scv['en_category']);}//中文$objActSheet->setCellValue('D'.$stapos,$fv['category']);$stopos=$stapos+$fv['second_count']-1;$mergecellstr='D'.$stapos.':D'.$stopos;$objActSheet->mergeCells($mergecellstr);//英文$objActSheet->setCellValue('D'.$en_stapos,$fv['en_category']);$en_stopos=$en_stapos+$fv['second_count']-1;$en_mergecellstr='D'.$en_stapos.':D'.$en_stopos;$objActSheet->mergeCells($en_mergecellstr);}修改以后的片段：$second_count=0;//歸總每個一級分類下的二級分類foreach($first_cate_arrayas$fkey=>$fvalue){//一級目錄起始行數(shù)$stapos=$num+$second_count;$en_stapos=$stapos+$cate_count;$second_stapos=0;foreach($cateas$ck=>$cv){if($cv['parentid']==$fvalue['id']){//二級目錄起始行數(shù)$stapos1=$stapos+$second_stapos;$en_stapos1=$en_stapos+$second_stapos;foreach($cv['pro']as$spk=>$spv){$str1=70+$spk*3;$str1=chr($str1);$str2=71+$spk*3;$str2=chr($str2);$str3=72+$spk*3;$str3=chr($str3);//中文$collect=$spv['name'].'（'.$spv['description'].'）';$objActSheet->setCellValue($str1.$stapos1,$collect);$objActSheet->setCellValue($str2.$stapos1,$spv['name']);$objActSheet->setCellValue($str3.$stapos1,$spv['description']);//英文$en_collect=$spv['en_name'].'('.$spv['en_description'].')';$objActSheet->setCellValue($str1.$en_stapos1,$en_collect);$objActSheet->setCellValue($str2.$en_stapos1,$spv['en_name']);$objActSheet->setCellValue($str3.$en_stapos1,$spv['en_description']);}//中文$objActSheet->setCellValue('E'.$stapos1,$cv['category']);//英文$objActSheet->setCellValue('E'.$en_stapos1,$cv['en_category']);$second_stapos++;$second_count++;}}//中文$objActSheet->setCellValue('D'.$stapos,$fvalue['category']);$stopos=$num+$second_count-1;$mergecellstr='D'.$stapos.':D'.$stopos;$objActSheet->mergeCells($mergecellstr);//英文$objActSheet->setCellValue('D'.$en_stapos,$fvalue['en_category']);$en_stopos=$num+$cate_count+$second_count-1;$en_mergecellstr='D'.$en_stapos.':D'.$en_stopos;$objActSheet->mergeCells($en_mergecellstr);}我覺得原先的代碼多一個上面的循環(huán)，時間應(yīng)該多一點。。。查詢1700條數(shù)據(jù)耗時84s。。。下面附上全文代碼：/***導(dǎo)出Execl*/publicfunctionexport(){import("@.ORG.PhpExcel");//import("Lib.ORG.PHPExcel.IOFactory",APP_PATH,".php");import("Lib.ORG.PHPExcel.Writer.Excel5",APP_PATH,".php");import("Lib.ORG.PHPExcel.Writer.Excel2007",APP_PATH,".php");//創(chuàng)建一個處理對象實例$objPHPExcel=newPHPExcel();//創(chuàng)建文件格式寫入對象實例,uncomment//$objWriter=newPHPExcel_Writer_Excel5($objPHPExcel);//用于其他版本格式//or$objWriter=newPHPExcel_Writer_Excel2007($objPHPExcel);//用于2007格式//$objWriter->setOffice2003Compatibility(true);//*************************************//設(shè)置文檔基本屬性//$objProps=$objPHPExcel->getProperties();//$objProps->setCreator("Test");//創(chuàng)建人//$objProps->setLastModifiedBy("Test");//最后修改人//$objProps->setTitle("OfficeXLSTestDocument");//標題//$objProps->setSubject("OfficeXLSTestDocument,Demo");//題目//$objProps->setDescription("Testdocument,generatedbyPHPExcel.");//描述//$objProps->setKeywords("officeexcelPHPExcel");//關(guān)鍵字//$objProps->setCategory("Test");//種類//*************************************//設(shè)置當前的sheet索引，用于后續(xù)的內(nèi)容操作。//一般只有在使用多個sheet的時候才需要顯示調(diào)用。//缺省情況下，PHPExcel會自動創(chuàng)建第一個sheet被設(shè)置SheetIndex=0$objPHPExcel->setActiveSheetIndex(0);$objActSheet=$objPHPExcel->getActiveSheet();//設(shè)置當前活動sheet的名稱//$objActSheet->setTitle('測試Sheet');//*************************************//設(shè)置單元格內(nèi)容////由PHPExcel根據(jù)傳入內(nèi)容自動判斷單元格內(nèi)容類型//$objActSheet->setCellValue('A1','字符串內(nèi)容');//字符串內(nèi)容//$objActSheet->setCellValue('A2',26);//數(shù)值//$objActSheet->setCellValue('A3',true);//布爾值//$objActSheet->setCellValue('A4','=SUM(A2:A2)');//公式//填入主標題$objActSheet->setCellValue('A1','電子地圖');$objActSheet->mergeCells('A1:AC1');//設(shè)置表頭行高$objActSheet->getRowDimension(1)->setRowHeight(20);$objActSheet->setCellValue('A2','序號');$objActSheet->mergeCells('A2:A4');$objActSheet->setCellValue('B2','公司名稱');$objActSheet->mergeCells('B2:B4');$objActSheet->setCellValue('C2','簡稱');$objActSheet->mergeCells('C2:C4');$objActSheet->setCellValue('D2','產(chǎn)品與技術(shù)');$objActSheet->mergeCells('D2:N2');$objActSheet->setCellValue('O2','相關(guān)信息');$objActSheet->mergeCells('O2:S2');$objActSheet->setCellValue('T2','聯(lián)系信息');$objActSheet->mergeCells('T2:AB2');$objActSheet->setCellValue('AC2','描述');$objActSheet->mergeCells('AC2:AC4');$objActSheet->setCellValue('D3','領(lǐng)域');$objActSheet->mergeCells('D3:E3');$objActSheet->setCellValue('F3','產(chǎn)品');$objActSheet->mergeCells('F3:N3');$objActSheet->setCellValue('O3','技術(shù)');$objActSheet->mergeCells('O3:O4');$objActSheet->setCellValue('P3','應(yīng)用');$objActSheet->mergeCells('P3:P4');$objActSheet->setCellValue('Q3','性質(zhì)');$objActSheet->mergeCells('Q3:Q4');$objActSheet->setCellValue('R3','成立時間');$objActSheet->mergeCells('R3:R4');$objActSheet->setCellValue('S3','員工數(shù)');$objActSheet->mergeCells('S3:S4');$objActSheet->setCellValue('T3','地址');$objActSheet->mergeCells('T3:T4');$objActSheet->setCellValue('U3','電話');$objActSheet->mergeCells('U3:U4');$objActSheet->setCellValue('V3','傳真');$objActSheet->mergeCells('V3:V4');$objActSheet->setCellValue('W3','eMail');$objActSheet->mergeCells('W3:W4');$objActSheet->setCellValue('X3','網(wǎng)站');$objActSheet->mergeCells('X3:X4');$objActSheet->setCellValue('Y3','經(jīng)度');$objActSheet->mergeCells('Y3:Y4');$objActSheet->setCellValue('Z3','緯度');$objActSheet->mergeCells('Z3:Z4');$objActSheet->setCellValue('AA3','園區(qū)');$objActSheet->mergeCells('AA3:AA4');$objActSheet->setCellValue('AB3','城市');$objActSheet->mergeCells('AB3:AB4');$objActSheet->setCellValue('D4','一級');$objActSheet->setCellValue('E4','二級');$objActSheet->setCellValue('F4','1');$objActSheet->setCellValue('G4','品名');$objActSheet->setCellValue('H4','描述');$objActSheet->setCellValue('I4','2');$objActSheet->setCellValue('J4','品名');$objActSheet->setCellValue('K4','描述');$objActSheet->setCellValue('L4','3');$objActSheet->setCellValue('M4','品名');$objActSheet->setCellValue('N4','描述');//*************************************//搜索條件$company_where=1;$keyword=trim($_GET['keyword']);if($_GET['sub_category']||$_GET['first_cid']){$c_uid=getuidbycate();}if($_GET['product_id']){$p_uid=getuidbypro($_GET['product_id']);}$uid_arr=$p_uid?array_intersect($c_uid,$p_uid):$c_uid;$uid_str=implode(',',$uid_arr);if($_GET['sub_category']||$_GET['first_cid']||$_GET['product_id']){$company_where.='anduidin('.$uid_str.')';}if($keyword){$company_where.="andcompanylike'%$keyword%'";}$num=5;//初始行數(shù)//公司信息$company=$this->Company->field('')->where($company_where)->select();if($company){foreach((array)$companyas$k=>$v){if($v['uid']){//獲取產(chǎn)品$pro=$this->Product->table(tname('product').'ASpr')->join(tname('company_product').'AScpONpr.id=cp.pid')->field('')->where('cp.uid='.$v['uid'])->group('pr.id')->select();$company[$k]['pid']=$pro;//獲取二級分類$join=tname('company_category').'ASccONca.id=cc.cid';$field='';$where="cc.uid=".$v['uid'];$cate=$this->Category->table(tname('category').'ASca')->join($join)->field($field)->where($where)->group('ca.id')->select();if($cate){$cate_count=count($cate);$second_cate='';$first_cate_array='';foreach($cateas$k1=>$v1){//獲取一級分類$first_cate=$this->Category->where('id='.$v1['parentid'])->find();//歸總公司的一級分類if(!in_array($first_cate,$first_cate_array)){$first_cate_array[]=$first_cate;}//歸類二級分類下的產(chǎn)品foreach($proas$pk=>$pv){if($pv['cid']==$v1['cid']){$cate[$k1]['pro'][]=$pv;}}}/**************************************************************************///$second_count=0;////歸總每個一級分類下的二級分類//foreach($first_cate_arrayas$fkey=>$fvalue){////一級目錄起始行數(shù)//$stapos=$num+$second_count;//$en_stapos=$stapos+$cate_count;//$second_stapos=0;//foreach($cateas$ck=>$cv){//if($cv['parentid']==$fvalue['id']){////二級目錄起始行數(shù)//$stapos1=$stapos+$second_stapos;//$en_stapos1=$en_stapos+$second_stapos;//foreach($cv['pro']as$spk=>$spv){//$str1=70+$spk*3;//$str1=chr($str1);//$str2=71+$spk*3;//$str2=chr($str2);//$str3=72+$spk*3;//$str3=chr($str3);////中文//$collect=$spv['name'].'（'.$spv['description'].'）';//$objActSheet->setCellValue($str1.$stapos1,$collect);//$objActSheet->setCellValue($str2.$stapos1,$spv['name']);//$objActSheet->setCellValue($str3.$stapos1,$spv['description']);////英文//$en_collect=$spv['en_name'].'('.$spv['en_description'].')';//$objActSheet->setCellValue($str1.$en_stapos1,$en_collect);//$objActSheet->setCellValue($str2.$en_stapos1,$spv['en_name']);//$objActSheet->setCellValue($str3.$en_stapos1,$spv['en_description']);//}////中文//$objActSheet->setCellValue('E'.$stapos1,$cv['category']);////英文//$objActSheet->setCellValue('E'.$en_stapos1,$cv['en_category']);//$second_stapos++;//$second_count++;//}//}////中文//$objActSheet->setCellValue('D'.$stapos,$fvalue['category']);//$stopos=$num+$second_count-1;//$mergecellstr='D'.$stapos.':D'.$stopos;//$objActSheet->mergeCells($mergecellstr);////英文//$objActSheet->setCellValue('D'.$en_stapos,$fvalue['en_category']);//$en_stopos=$num+$cate_count+$second_count-1;//$en_mergecellstr='D'.$en_stapos.':D'.$en_stopos;//$objActSheet->mergeCells($en_mergecellstr);//}/**************************************************************************///歸總每個一級分類下的二級分類foreach($first_cate_arrayas$fkey=>$fvalue){foreach($cateas$ck=>$cv){if($cv['parentid']==$fvalue['id']){$first_cate_array[$fkey]['second_cate'][]=$cv;}}//獲得每個一級分類下二級分類的數(shù)目$second_count=count($first_cate_array[$fkey]['second_cate']);$first_cate_array[$fkey]['second_count']=$second_count==0?1:$second_count;}/*************************************************************************/foreach($first_cate_arrayas$fk=>$fv){//一級目錄起始行數(shù)if($fk==0){$stapos=$num;$en_stapos=$stapos+$cate_count;}else{$stapos=$stapos+$first_cate_array[$fk-1]['second_count'];$en_stapos=$stapos+$cate_count;}foreach($fv['second_cate']as$sck=>$scv){//二級目錄起始行數(shù)$stapos1=$stapos+$sck;$en_stapos1=$en_stapos+$sck;foreach($scv['pro']as$spk=>$spv){$str1=70+$spk*3;$str1=chr($str1);$str2=71+$spk*3;$str2=chr($str2);$str3=72+$spk*3;$str3=chr($str3);//中文$collect=$spv['name'].'（'.$spv['description'].'）';$objActSheet->setCellValue($str1.$stapos1,$collect);$objActSheet->setCellValue($str2.$stapos1,$spv['name']);$objActSheet->setCellValue($str3.$stapos1,$spv['description']);//英文$en_collect=$spv['en_name'].'('.$spv['en_description'].')';$objActSheet->setCellValue($str1.$en_stapos1,$en_collect);$objActSheet->setCellValue($str2.$en_stapos1,$spv['en_name']);$objActSheet->setCellValue($str3.$en_stapos1,$spv['en_description']);}//中文$objActSheet->setCellValue('E'.$stapos1,$scv['category']);//英文$objActSheet->setCellValue('E'.$en_stapos1,$scv['en_category']);}//中文$objActSheet->setCellValue('D'.$stapos,$fv['category']);$stopos=$stapos+$fv['second_count']-1;$mergecellstr='D'.$stapos.':D'.$stopos;$objActSheet->mergeCells($mergecellstr);//英文$objActSheet->setCellValue('D'.$en_stapos,$fv['en_category']);$en_stopos=$en_stapos+$fv['second_count']-1;$en_mergecellstr='D'.$en_stapos.':D'.$en_stopos;$objActSheet->mergeCells($en_mergecellstr);}$company[$k]['first_cid']=$first_cate_array;}//$company[$k]['first_count']=count($company[$k]['first_cid']);//獲得二級分類的總數(shù)目$company[$k]['total_rows']=count($cate);//園區(qū)if($v['park']){$park=my_explode($v['park']);$company[$k]['park']=my_arrytostr(array_unique($park),'Park','name');$company[$k]['en_park']=my_arrytostr(array_unique($park),'Park','en_name');}else{$v['park']='';$v['en_park']='';}//城市if($v['city']){$city=C('CITY');foreach($cityas$ck=>$cv){if($v['city']==$cv['id']){$v['city']=$cv['name'];$v['en_city']=$cv['en_name'];}}}$total_rows=$company[$k]['total_rows']==0?1:$company[$k]['total_rows'];//中文*************************************$stop=$num-1+$total_rows;$objActSheet->setCellValue('A'.$num,$v['uid']);$objActSheet->mergeCells('A'.$num.':A'.$stop);$objActSheet->setCellValue('B'.$num,$v['company']);$objActSheet->mergeCells('B'.$num.':B'.$stop);$objActSheet->setCellValue('C'.$num,$v['com']);$objActSheet->mergeCells('C'.$num.':C'.$stop);////$objActSheet->setCellValue('D'.$num,$v['com']);//$objActSheet->setCellValue('E'.$num,$v['uid']);//$objActSheet->setCellValue('F'.$num,$v['uid']);//$objActSheet->setCellValue('G'.$num,$v['uid']);//$objActSheet->setCellValue('H'.$num,$v['uid']);//$objActSheet->setCellValue('I'.$num,$v['uid']);//$objActSheet->setCellValue('J'.$num,$v['uid']);//$objActSheet->setCellValue('K'.$num,$v['uid']);//$objActSheet->setCellValue('L'.$num,$v['uid']);//$objActSheet->setCellValue('M'.$num,$v['uid']);//$objActSheet->setCellValue('N'.$num,$v['uid']);//$objActSheet->setCellValue('O'.$num,$v['technology']);$objActSheet->mergeCells('O'.$num.':O'.$stop);$objActSheet->setCellValue('P'.$num,$v['application']);$objActSheet->mergeCells('P'.$num.':P'.$stop);$objActSheet->setCellValue('Q'.$num,$v['nature']);$objActSheet->mergeCells('Q'.$num.':Q'.$stop);$objActSheet->setCellValue('R'.$num,$v['established']);$objActSheet->mergeCells('R'.$num.':R'.$stop);$objActSheet->setCellValue('S'.$num,$v['employees']);$objActSheet->mergeCells('S'.$num.':S'.$stop);$objActSheet->setCellValue('T'.$num,$v['address']);$objActSheet->mergeCells('T'.$num.':T'.$stop);$objActSheet->setCellValue('U'.$num,$v['phone']);$objActSheet->mergeCells('U'.$num.':U'.$stop);$objActSheet->setCellValue('V'.$num,$v['fax']);$objActSheet->mergeCells('V'.$num.':V'.$stop);$objActSheet->setCellValue('W'.$num,$v['email']);$objActSheet->mergeCells('W'.$num.':W'.$stop);$objActSheet->setCellValue('X'.$num,$v['website']);$objActSheet->mergeCells('X'.$num.':X'.$stop);$objActSheet->setCellValue('Y'.$num,$v['longitude']);$objActSheet->mergeCells('Y'.$num.':Y'.$stop);$objActSheet->setCellValue('Z'.$num,$v['latitude']);$objActSheet->mergeCells('Z'.$num.':Z'.$stop);$objActSheet->setCellValue('AA'.$num,$v['park']);$objActSheet->mergeCells('AA'.$num.':AA'.$stop);$objActSheet->setCellValue('AB'.$num,$v['city']);$objActSheet->mergeCells('AB'.$num.':AB'.$stop);$objActSheet->setCellValue('AC'.$num,$v['description']);$objActSheet->mergeCells('AC'.$num.':AC'.$stop);//英文*************************************$en_start=$num+$total_rows;$en_stop=$en_start-1+$total_rows;$objActSheet->setCellValue('A'.$en_start,$v['uid']);$objActSheet->mergeCells('A'.$en_start.':A'.$en_stop);$objActSheet->setCellValue('B'.$en_start,$v['en_company']);$objActSheet->mergeCells('B'.$en_start.':B'.$en_stop);$objActSheet->setCellValue('C'.$en_start,$v['en_com']);$objActSheet->mergeCells('C'.$en_start.':C'.$en_stop);////$objActSheet->setCellValue('D'.$en_start,$v['com']);//$objActSheet->setCellValue('E'.$en_start,$v['uid']);//$objActSheet->setCellValue('F'.$en_start,$v['uid']);//$objActSheet->setCellValue('G'.$en_start,$v['uid']);//$objActSheet->setCellValue('H'.$en_start,$v['uid']);//$objActSheet->setCellValue('I'.$en_start,$v['uid']);//$objActSheet->setCellValue('J'.$en_start,$v['uid']);//$objActSheet->setCellValue('K'.$en_start,$v['uid']);//$objActSheet->setCellValue('L'.$en_start,$v['uid']);//$objActSheet->setCellValue('M'.$en_start,$v['uid']);//$objActSheet->setCellValue('N'.$en_start,$v['uid']);//$objActSheet->setCellValue('O'.$en_start,$v['en_technology']);$objActSheet->mergeCells('O'.$en_start.':O'.$en_stop);$objActSheet->setCellValue('P'.$en_start,$v['en_application']);$objActSheet->mergeCells('P'.$en_start.':P'.$en_stop);$objActSheet->setCellValue('Q'.$en_start,$v['en_nature']);$objActSheet->mergeCells('Q'.$en_start.':Q'.$en_stop);$objActSheet->setCellValue('R'.$en_start,$v['established']);$objActSheet->mergeCells('R'.$en_start.':R'.$en_stop);$objActSheet->setCellValue('S'.$en_start,$v['employees']);$objActSheet->mergeCells('S'.$en_start.':S'.$en_stop);$objActSheet->setCellValue('T'.$en_start,$v['en_address']);$objActSheet->mergeCells('T'.$en_start.':T'.$en_stop);$objActSheet->setCellValue('U'.$en_start,$v['phone']);$objActSheet->mergeCells('U'.$en_start.':U'.$en_stop);$objActSheet->setCellValue('V'.$en_start,$v['fax']);$objActSheet->mergeCells('V'.$en_start.':V'.$en_stop);$objActSheet->setCellValue('W'.$en_start,$v['email']);$objActSheet->mergeCells('W'.$en_start.':W'.$en_stop);$objActSheet->setCellValue('X'.$en_start,$v['website']);$objActSheet->mergeCells('X'.$en_start.':X'.$en_stop);$objActSheet->setCellValue('Y'.$en_start,$v['longitude']);$objActSheet->mergeCells('Y'.$en_start.':Y'.$en_stop);$objActSheet->setCellValue('Z'.$en_start,$v['latitude']);$objActSheet->mergeCells('Z'.$en_start.':Z'.$en_stop);$objActSheet->setCellValue('AA'.$en_start,$v['en_park']);$objActSheet->mergeCells('AA'.$en_start.':AA'.$en_stop);$objActSheet->setCellValue('AB'.$en_start,$v['en_city']);$objActSheet->mergeCells('AB'.$en_start.':AB'.$en_stop);$objActSheet->setCellValue('AC'.$en_start,$v['en_description']);$objActSheet->mergeCells('AC'.$en_start.':AC'.$en_stop);$num+=$company[$k]['total_rows']*2;//下一公司的起始行數(shù)}}}//*************************************//設(shè)置單元格樣式////設(shè)置主標題字體$objStyleA1=$objActSheet->getStyle('A1');$objFontA1=$objStyleA1->getFont();$objFontA1->setName('宋體');$objFontA1->setSize(14);//$objFontA1->setBold(false);//$objFontA1->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);//$objFontA1->getColor()->setARGB('FF999999');//*************************************//設(shè)置表頭字體$objStyleA2=$objActSheet->getStyle('A2:AC4');$objFontA2=$objStyleA2->getFont();$objFontA2->setName('Cambria');$objFontA2->setSize(10);//設(shè)置填充顏色$objFillA2=$objStyleA2->getFill();$objFillA2->setFillType(PHPExcel_Style_Fill::FILL_SOLID);$objFillA2->getStartColor()->setARGB('B7B7B7');//從指定的單元格復(fù)制樣式信息.//$objActSheet->duplicateStyle($objStyleA2,'A2:AC4');//*************************************//設(shè)置表格字體$objActSheet->getStyle('A1:AC'.($num-1))->getFont()->setName('Cambria');$objActSheet->getStyle('A1:AC'.($num-1))->getFont()->setSize(9);//顯示網(wǎng)格線:$objActSheet->setShowGridlines(true);//設(shè)置自動換行$objActSheet->getStyle('A1:AC'.($num-1))->getAlignment()->setWrapText(true);//所有垂直居中$objActSheet->getStyle('A1:AC'.($num-1))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);//前4行水平居中$objActSheet->getStyle('A1:AC4')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//后面水平左對齊$objActSheet->getStyle('A5:AC'.($num-1))->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);//設(shè)置單元格邊框$objActSheet->getStyle('A1:AC'.($num-1))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);$objActSheet->getStyle('A1:AC'.($num-1))->getBorders()->getAllBorders()->getColor()->setARGB('000000');//*************************************//輸出內(nèi)容//下面的路徑按照你PHPExcel的路徑來修改//$outputFileName="output.xlsx";//$outputFileName="output.xls";//到文件//$objWriter->save($outputFileName);//or//到瀏覽器header("Content-Type:application/force-download");header("Content-Type:application/octet-stream");header("Content-Type:application/download");header('Content-Disposition:inline;filename="'.$outputFileName.'"');header("Content-Transfer-Encoding:binary");header("Expires:Mon,26Jul199705:00:00GMT");header("Last-Modified:".gmdate("D,dMYH:i:s")."GMT");header("Cache-Control:must-revalidate,post-check=0,pre-check=0");header("Pragma:no-cache");$objWriter->save('php://output');}