做php导出，需要循环输出数据到execl中，一开始写了一个，觉得时间有点长，就缩短了下，发现时间还变多了，求教这是为什么啊？谢谢了先。
原先的代码片段：
<code>//归总每个一级分类下的二级分类
foreach($first_cate_array as $fkey => $fvalue){
foreach($cate as $ck=>$cv){
if($cv['parentid'] == $fvalue['id']){
$first_cate_array[$fkey]['second_cate'][] = $cv;
}
}
//获得每个一级分类下二级分类的数目
$second_count = count($first_cate_array[$fkey]['second_cate']);
$first_cate_array[$fkey]['second_count'] = $second_count == 0 ? 1 : $second_count;
}
/*************************************************************************/
foreach($first_cate_array as $fk => $fv){
//一级目录起始行数
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){
//二级目录起始行数
$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);
}
</code>
修改以后的片段：
<code>$second_count = 0;
//归总每个一级分类下的二级分类
foreach($first_cate_array as $fkey => $fvalue){
//一级目录起始行数
$stapos = $num+$second_count;
$en_stapos = $stapos+$cate_count;
$second_stapos = 0;
foreach($cate as $ck=>$cv){
if($cv['parentid'] == $fvalue['id']){
//二级目录起始行数
$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);
}
</code>
我觉得原先的代码多一个上面的循环，时间应该多一点。。。查询1700条数据耗时84s。。。 下面附上全文代码：
/**
* 导出Execl
*/
public function export(){
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");
// 创建一个处理对象实例
$objPHPExcel = new PHPExcel();
// 创建文件格式写入对象实例, uncomment
//$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel); // 用于其他版本格式
// or
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); // 用于 2007 格式
//$objWriter->setOffice2003Compatibility(true);
//*************************************
//设置文档基本属性
// $objProps = $objPHPExcel->getProperties();
// $objProps->setCreator("Test"); //创建人
// $objProps->setLastModifiedBy("Test"); //最后修改人
// $objProps->setTitle("Office XLS Test Document"); //标题
// $objProps->setSubject("Office XLS Test Document, Demo"); //题目
// $objProps->setDescription("Test document, generated by PHPExcel."); //描述
// $objProps->setKeywords("office excel PHPExcel"); //关键字
// $objProps->setCategory("Test"); //种类
//*************************************
//设置当前的sheet索引，用于后续的内容操作。
//一般只有在使用多个sheet的时候才需要显示调用。
//缺省情况下，PHPExcel会自动创建第一个sheet被设置SheetIndex=0
$objPHPExcel->setActiveSheetIndex(0);
$objActSheet = $objPHPExcel->getActiveSheet();
//设置当前活动sheet的名称
//$objActSheet->setTitle('测试Sheet');
//*************************************
//设置单元格内容
//
//由PHPExcel根据传入内容自动判断单元格内容类型
//$objActSheet->setCellValue('A1', '字符串内容'); // 字符串内容
//$objActSheet->setCellValue('A2', 26); // 数值
//$objActSheet->setCellValue('A3', true); // 布尔值
//$objActSheet->setCellValue('A4', '=SUM(A2:A2)'); // 公式
//填入主标题
$objActSheet->setCellValue('A1', '电子地图');
$objActSheet->mergeCells('A1:AC1');
//设置表头行高
$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', '产品与技术');
$objActSheet->mergeCells('D2:N2');
$objActSheet->setCellValue('O2', '相关信息');
$objActSheet->mergeCells('O2:S2');
$objActSheet->setCellValue('T2', '联系信息');
$objActSheet->mergeCells('T2:AB2');
$objActSheet->setCellValue('AC2', '描述');
$objActSheet->mergeCells('AC2:AC4');
$objActSheet->setCellValue('D3', '领域');
$objActSheet->mergeCells('D3:E3');
$objActSheet->setCellValue('F3', '产品');
$objActSheet->mergeCells('F3:N3');
$objActSheet->setCellValue('O3', '技术');
$objActSheet->mergeCells('O3:O4');
$objActSheet->setCellValue('P3', '应用');
$objActSheet->mergeCells('P3:P4');
$objActSheet->setCellValue('Q3', '性质');
$objActSheet->mergeCells('Q3:Q4');
$objActSheet->setCellValue('R3', '成立时间');
$objActSheet->mergeCells('R3:R4');
$objActSheet->setCellValue('S3', '员工数');
$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', '网站');
$objActSheet->mergeCells('X3:X4');
$objActSheet->setCellValue('Y3', '经度');
$objActSheet->mergeCells('Y3:Y4');
$objActSheet->setCellValue('Z3', '纬度');
$objActSheet->mergeCells('Z3:Z4');
$objActSheet->setCellValue('AA3', '园区');
$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 .= ' and uid in('.$uid_str.')';
}
if($keyword){
$company_where .= " and company like '%$keyword%'";
}
$num = 5; //初始行数
//公司信息
$company = $this->Company->field('')->where($company_where)->select();
if($company){
foreach((array)$company as $k => $v){
if($v['uid']){
//获取产品
$pro = $this->Product->table(tname('product').' AS pr')->join(tname('company_product').' AS cp ON pr.id=cp.pid')->field('')->where('cp.uid='.$v['uid'])->group('pr.id')->select();
$company[$k]['pid'] = $pro;
//获取二级分类
$join = tname('company_category').' AS cc ON ca.id=cc.cid';
$field = '';
$where = "cc.uid=".$v['uid'];
$cate = $this->Category->table(tname('category').' AS ca')->join($join)->field($field)->where($where)->group('ca.id')->select();
if($cate){
$cate_count = count($cate);
$second_cate = '';
$first_cate_array = '';
foreach($cate as $k1=>$v1){
//获取一级分类
$first_cate = $this->Category->where('id='.$v1['parentid'])->find();
//归总公司的一级分类
if(!in_array($first_cate,$first_cate_array)){
$first_cate_array[] = $first_cate;
}
//归类二级分类下的产品
foreach($pro as $pk => $pv){
if($pv['cid'] == $v1['cid']){
$cate[$k1]['pro'][] = $pv;
}
}
}
/**************************************************************************/
// $second_count = 0;
// //归总每个一级分类下的二级分类
// foreach($first_cate_array as $fkey => $fvalue){
// //一级目录起始行数
// $stapos = $num+$second_count;
// $en_stapos = $stapos+$cate_count;
// $second_stapos = 0;
// foreach($cate as $ck=>$cv){
// if($cv['parentid'] == $fvalue['id']){
// //二级目录起始行数
// $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_array as $fkey => $fvalue){
foreach($cate as $ck=>$cv){
if($cv['parentid'] == $fvalue['id']){
$first_cate_array[$fkey]['second_cate'][] = $cv;
}
}
//获得每个一级分类下二级分类的数目
$second_count = count($first_cate_array[$fkey]['second_cate']);
$first_cate_array[$fkey]['second_count'] = $second_count == 0 ? 1 : $second_count;
}
/*************************************************************************/
foreach($first_cate_array as $fk => $fv){
//一级目录起始行数
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){
//二级目录起始行数
$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']);
//获得二级分类的总数目
$company[$k]['total_rows'] = count($cate);
//园区
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($city as $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; //下一公司的起始行数
}
}
}
//*************************************
//设置单元格样式
//
//设置主标题字体
$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');
//*************************************
//设置表头字体
$objStyleA2 = $objActSheet->getStyle('A2:AC4');
$objFontA2 = $objStyleA2->getFont();
$objFontA2->setName('Cambria');
$objFontA2->setSize(10);
//设置填充颜色
$objFillA2 = $objStyleA2->getFill();
$objFillA2->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objFillA2->getStartColor()->setARGB('B7B7B7');
//从指定的单元格复制样式信息.
//$objActSheet->duplicateStyle($objStyleA2, 'A2:AC4');
//*************************************
//设置表格字体
$objActSheet->getStyle('A1:AC'.($num-1))->getFont()->setName('Cambria');
$objActSheet->getStyle('A1:AC'.($num-1))->getFont()->setSize(9);
//显示网格线:
$objActSheet->setShowGridlines(true);
//设置自动换行
$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);
//设置单元格边框
$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');
//*************************************
//输出内容
//下面的路径按照你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, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Pragma: no-cache");
$objWriter->save('php://output');
}
回复内容：
做php导出，需要循环输出数据到execl中，一开始写了一个，觉得时间有点长，就缩短了下，发现时间还变多了，求教这是为什么啊？谢谢了先。
原先的代码片段：
<code>//归总每个一级分类下的二级分类
foreach($first_cate_array as $fkey => $fvalue){
foreach($cate as $ck=>$cv){
if($cv['parentid'] == $fvalue['id']){
$first_cate_array[$fkey]['second_cate'][] = $cv;
}
}
//获得每个一级分类下二级分类的数目
$second_count = count($first_cate_array[$fkey]['second_cate']);
$first_cate_array[$fkey]['second_count'] = $second_count == 0 ? 1 : $second_count;
}
/*************************************************************************/
foreach($first_cate_array as $fk => $fv){
//一级目录起始行数
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){
//二级目录起始行数
$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);
}
</code>
修改以后的片段：
<code>$second_count = 0;
//归总每个一级分类下的二级分类
foreach($first_cate_array as $fkey => $fvalue){
//一级目录起始行数
$stapos = $num+$second_count;
$en_stapos = $stapos+$cate_count;
$second_stapos = 0;
foreach($cate as $ck=>$cv){
if($cv['parentid'] == $fvalue['id']){
//二级目录起始行数
$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);
}
</code>
我觉得原先的代码多一个上面的循环，时间应该多一点。。。查询1700条数据耗时84s。。。 下面附上全文代码：
<code class="lang-php"> /**
* 导出Execl
*/
public function export(){
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");
// 创建一个处理对象实例
$objPHPExcel = new PHPExcel();
// 创建文件格式写入对象实例, uncomment
//$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel); // 用于其他版本格式
// or
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); // 用于 2007 格式
//$objWriter->setOffice2003Compatibility(true);
//*************************************
//设置文档基本属性
// $objProps = $objPHPExcel->getProperties();
// $objProps->setCreator("Test"); //创建人
// $objProps->setLastModifiedBy("Test"); //最后修改人
// $objProps->setTitle("Office XLS Test Document"); //标题
// $objProps->setSubject("Office XLS Test Document, Demo"); //题目
// $objProps->setDescription("Test document, generated by PHPExcel."); //描述
// $objProps->setKeywords("office excel PHPExcel"); //关键字
// $objProps->setCategory("Test"); //种类
//*************************************
//设置当前的sheet索引，用于后续的内容操作。
//一般只有在使用多个sheet的时候才需要显示调用。
//缺省情况下，PHPExcel会自动创建第一个sheet被设置SheetIndex=0
$objPHPExcel->setActiveSheetIndex(0);
$objActSheet = $objPHPExcel->getActiveSheet();
//设置当前活动sheet的名称
//$objActSheet->setTitle('测试Sheet');
//*************************************
//设置单元格内容
//
//由PHPExcel根据传入内容自动判断单元格内容类型
//$objActSheet->setCellValue('A1', '字符串内容'); // 字符串内容
//$objActSheet->setCellValue('A2', 26); // 数值
//$objActSheet->setCellValue('A3', true); // 布尔值
//$objActSheet->setCellValue('A4', '=SUM(A2:A2)'); // 公式
//填入主标题
$objActSheet->setCellValue('A1', '电子地图');
$objActSheet->mergeCells('A1:AC1');
//设置表头行高
$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', '产品与技术');
$objActSheet->mergeCells('D2:N2');
$objActSheet->setCellValue('O2', '相关信息');
$objActSheet->mergeCells('O2:S2');
$objActSheet->setCellValue('T2', '联系信息');
$objActSheet->mergeCells('T2:AB2');
$objActSheet->setCellValue('AC2', '描述');
$objActSheet->mergeCells('AC2:AC4');
$objActSheet->setCellValue('D3', '领域');
$objActSheet->mergeCells('D3:E3');
$objActSheet->setCellValue('F3', '产品');
$objActSheet->mergeCells('F3:N3');
$objActSheet->setCellValue('O3', '技术');
$objActSheet->mergeCells('O3:O4');
$objActSheet->setCellValue('P3', '应用');
$objActSheet->mergeCells('P3:P4');
$objActSheet->setCellValue('Q3', '性质');
$objActSheet->mergeCells('Q3:Q4');
$objActSheet->setCellValue('R3', '成立时间');
$objActSheet->mergeCells('R3:R4');
$objActSheet->setCellValue('S3', '员工数');
$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', '网站');
$objActSheet->mergeCells('X3:X4');
$objActSheet->setCellValue('Y3', '经度');
$objActSheet->mergeCells('Y3:Y4');
$objActSheet->setCellValue('Z3', '纬度');
$objActSheet->mergeCells('Z3:Z4');
$objActSheet->setCellValue('AA3', '园区');
$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 .= ' and uid in('.$uid_str.')';
}
if($keyword){
$company_where .= " and company like '%$keyword%'";
}
$num = 5; //初始行数
//公司信息
$company = $this->Company->field('')->where($company_where)->select();
if($company){
foreach((array)$company as $k => $v){
if($v['uid']){
//获取产品
$pro = $this->Product->table(tname('product').' AS pr')->join(tname('company_product').' AS cp ON pr.id=cp.pid')->field('')->where('cp.uid='.$v['uid'])->group('pr.id')->select();
$company[$k]['pid'] = $pro;
//获取二级分类
$join = tname('company_category').' AS cc ON ca.id=cc.cid';
$field = '';
$where = "cc.uid=".$v['uid'];
$cate = $this->Category->table(tname('category').' AS ca')->join($join)->field($field)->where($where)->group('ca.id')->select();
if($cate){
$cate_count = count($cate);
$second_cate = '';
$first_cate_array = '';
foreach($cate as $k1=>$v1){
//获取一级分类
$first_cate = $this->Category->where('id='.$v1['parentid'])->find();
//归总公司的一级分类
if(!in_array($first_cate,$first_cate_array)){
$first_cate_array[] = $first_cate;
}
//归类二级分类下的产品
foreach($pro as $pk => $pv){
if($pv['cid'] == $v1['cid']){
$cate[$k1]['pro'][] = $pv;
}
}
}
/**************************************************************************/
// $second_count = 0;
// //归总每个一级分类下的二级分类
// foreach($first_cate_array as $fkey => $fvalue){
// //一级目录起始行数
// $stapos = $num+$second_count;
// $en_stapos = $stapos+$cate_count;
// $second_stapos = 0;
// foreach($cate as $ck=>$cv){
// if($cv['parentid'] == $fvalue['id']){
// //二级目录起始行数
// $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_array as $fkey => $fvalue){
foreach($cate as $ck=>$cv){
if($cv['parentid'] == $fvalue['id']){
$first_cate_array[$fkey]['second_cate'][] = $cv;
}
}
//获得每个一级分类下二级分类的数目
$second_count = count($first_cate_array[$fkey]['second_cate']);
$first_cate_array[$fkey]['second_count'] = $second_count == 0 ? 1 : $second_count;
}
/*************************************************************************/
foreach($first_cate_array as $fk => $fv){
//一级目录起始行数
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){
//二级目录起始行数
$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']);
//获得二级分类的总数目
$company[$k]['total_rows'] = count($cate);
//园区
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($city as $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; //下一公司的起始行数
}
}
}
//*************************************
//设置单元格样式
//
//设置主标题字体
$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');
//*************************************
//设置表头字体
$objStyleA2 = $objActSheet->getStyle('A2:AC4');
$objFontA2 = $objStyleA2->getFont();
$objFontA2->setName('Cambria');
$objFontA2->setSize(10);
//设置填充颜色
$objFillA2 = $objStyleA2->getFill();
$objFillA2->setFillType(PHPExcel_Style_Fill::FILL_SOLID);
$objFillA2->getStartColor()->setARGB('B7B7B7');
//从指定的单元格复制样式信息.
//$objActSheet->duplicateStyle($objStyleA2, 'A2:AC4');
//*************************************
//设置表格字体
$objActSheet->getStyle('A1:AC'.($num</code>声明
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
超越炒作：评估当今PHP的角色Apr 12, 2025 am 12:17 AMPHP在现代编程中仍然是一个强大且广泛使用的工具，尤其在web开发领域。1)PHP易用且与数据库集成无缝，是许多开发者的首选。2)它支持动态内容生成和面向对象编程，适合快速创建和维护网站。3)PHP的性能可以通过缓存和优化数据库查询来提升，其广泛的社区和丰富生态系统使其在当今技术栈中仍具重要地位。
PHP中的弱参考是什么？什么时候有用？Apr 12, 2025 am 12:13 AM在PHP中，弱引用是通过WeakReference类实现的，不会阻止垃圾回收器回收对象。弱引用适用于缓存系统和事件监听器等场景，需注意其不能保证对象存活，且垃圾回收可能延迟。
解释PHP中的__ Invoke Magic方法。Apr 12, 2025 am 12:07 AM\_\_invoke方法允许对象像函数一样被调用。1.定义\_\_invoke方法使对象可被调用。2.使用$obj(...)语法时，PHP会执行\_\_invoke方法。3.适用于日志记录和计算器等场景，提高代码灵活性和可读性。
解释PHP 8.1中的纤维以进行并发。Apr 12, 2025 am 12:05 AMFibers在PHP8.1中引入，提升了并发处理能力。1)Fibers是一种轻量级的并发模型，类似于协程。2)它们允许开发者手动控制任务的执行流，适合处理I/O密集型任务。3)使用Fibers可以编写更高效、响应性更强的代码。
PHP社区：资源，支持和发展Apr 12, 2025 am 12:04 AMPHP社区提供了丰富的资源和支持，帮助开发者成长。1)资源包括官方文档、教程、博客和开源项目如Laravel和Symfony。2)支持可以通过StackOverflow、Reddit和Slack频道获得。3)开发动态可以通过关注RFC了解。4)融入社区可以通过积极参与、贡献代码和学习分享来实现。
PHP与Python：了解差异Apr 11, 2025 am 12:15 AMPHP和Python各有优势，选择应基于项目需求。1.PHP适合web开发，语法简单，执行效率高。2.Python适用于数据科学和机器学习，语法简洁，库丰富。
php：死亡还是简单地适应？Apr 11, 2025 am 12:13 AMPHP不是在消亡，而是在不断适应和进化。1)PHP从1994年起经历多次版本迭代，适应新技术趋势。2)目前广泛应用于电子商务、内容管理系统等领域。3)PHP8引入JIT编译器等功能，提升性能和现代化。4)使用OPcache和遵循PSR-12标准可优化性能和代码质量。
PHP的未来：改编和创新Apr 11, 2025 am 12:01 AMPHP的未来将通过适应新技术趋势和引入创新特性来实现：1)适应云计算、容器化和微服务架构，支持Docker和Kubernetes；2)引入JIT编译器和枚举类型，提升性能和数据处理效率；3)持续优化性能和推广最佳实践。
热AI工具
Undresser.AI Undress
人工智能驱动的应用程序，用于创建逼真的裸体照片
AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。
Undress AI Tool
免费脱衣服图片
Clothoff.io
AI脱衣机
AI Hentai Generator
免费生成ai无尽的。
热门文章
R.E.P.O.能量晶体解释及其做什么（黄色晶体）
3 周前By尊渡假赌尊渡假赌尊渡假赌
R.E.P.O.最佳图形设置
3 周前By尊渡假赌尊渡假赌尊渡假赌
刺客信条阴影：贝壳谜语解决方案
2 周前ByDDD
R.E.P.O.如果您听不到任何人，如何修复音频
3 周前By尊渡假赌尊渡假赌尊渡假赌
WWE 2K25：如何解锁Myrise中的所有内容
4 周前By尊渡假赌尊渡假赌尊渡假赌
热工具
SublimeText3 Mac版
神级代码编辑软件(SublimeText3)
DVWA
Damn Vulnerable Web App (DVWA) 是一个PHP/MySQL的Web应用程序，非常容易受到攻击。它的主要目标是成为安全专业人员在合法环境中测试自己的技能和工具的辅助工具，帮助Web开发人员更好地理解保护Web应用程序的过程，并帮助教师/学生在课堂环境中教授/学习Web应用程序安全。DVWA的目标是通过简单直接的界面练习一些最常见的Web漏洞，难度各不相同。请注意，该软件中
SublimeText3汉化版
中文版，非常好用
mPDF
mPDF是一个PHP库，可以从UTF-8编码的HTML生成PDF文件。原作者Ian Back编写mPDF以从他的网站上“即时”输出PDF文件，并处理不同的语言。与原始脚本如HTML2FPDF相比，它的速度较慢，并且在使用Unicode字体时生成的文件较大，但支持CSS样式等，并进行了大量增强。支持几乎所有语言，包括RTL（阿拉伯语和希伯来语）和CJK（中日韩）。支持嵌套的块级元素（如P、DIV），
EditPlus 中文破解版
体积小，语法高亮，不支持代码提示功能
