Create a Multi-Sheet Excel Workbooks By PHPExcel || PHPExcel 多sheet的excel

最新推荐文章于 2021-11-01 16:01:53 发布

舒浅

最新推荐文章于 2021-11-01 16:01:53 发布

阅读量4.1k

点赞数

分类专栏： PHP

本文链接：https://blog.csdn.net/ouyangyiqin/article/details/39580267

版权

PHP 专栏收录该内容

52 篇文章 0 订阅

订阅专栏

PHPExcel 1.7.6

$list :

PHPexcel:

	$objPHPExcel = new PHPExcel();
		$objPHPExcel->removeSheetByIndex(0);//去除默认的
		$objPHPExcel->getDefaultStyle()->getFont()->setName('微软雅黑');


     foreach ($list as $sheet_index => $va) {
     	$objPHPExcel->createSheet();
     	$objPHPExcel->setActiveSheetIndex($sheet_index);
     	if($sheet_index==0){
			$objPHPExcel->getActiveSheet()->setTitle("全省");//全省
     	}else{
     		$objPHPExcel->getActiveSheet()->setTitle(mb_substr($va[0]['area'], 3,mb_strlen($va[0]['area'],"utf-8"),"utf-8"));//各地市
     	}


		$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true); 
		$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(22); 
		$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25); 

     	$rowTitle = array('HOST', '一级分类|二级分类', '独立IP数','PV数');
		
		foreach($rowTitle as $k=>$r){
			$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($k, 1)->getFont()->setBold(true);//字体加粗
			$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow($k, 1)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//文字居中
			$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($k, 1, $r);
		}


		    $i=2;//从第二行开始
			$j=1;

			foreach ($va as $v_) {
				$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, $i, $v_['host']);
				$objPHPExcel->getActiveSheet()->getStyleByColumnAndRow(1,$i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);//文字居左
				$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, $i, $v_['cate']);
				$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(2, $i, $v_['ip']);
				$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(3, $i, $v_['pv']);
				$i++;
			    $j++;
			}
				
		

	}
    
    $objPHPExcel->setActiveSheetIndex(0);//默认显示第一个sheet 
	
	$filename="全省及各地市整体流量分布_{$date}.xls"; 
	header('Content-Type: application/vnd.ms-excel');
	header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name
	header('Cache-Control: max-age=0'); //no cache
	

	$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
	
	$objWriter->save('php://output');

export it:

舒浅

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Create a Multi-Sheet Excel Workbooks By PHPExcel || PHPExcel 多sheet的excel

$list :Array( [0] => Array ( [0] => Array ( [area] => all [host] => mp.weixin.qq.com [cate] => IT
复制链接

扫一扫

专栏目录