phpexecl 多sheet使用
<?php
include ‘excel/PHPExcel.php’;
include ‘excel/PHPExcel/Writer/Excel5.php’;
//创建一个excel
$objPHPExcel = new PHPExcel();
//——————————————————————————————————————–
$i=1;
foreach ($array as $k=>$v) {
//第一个sheet
if ($i==1){
//设置当前的sheet
$objPHPExcel->setActiveSheetIndex(0);
//设置sheet的name
$objPHPExcel->getActiveSheet()->setTitle(’sheetname1′);
//设置单元格的值
$objPHPExcel->getActiveSheet()->setCellValue(‘A1′, ‘test’);
$number = 1;
foreach ($v as $k1=>$v1){
$number++;
$objPHPExcel->getActiveSheet()->setCellValueExplicit(‘A’.$number, ”.$v1['data'].”);
}
}else{
//添加一个新的worksheet
$index[$i]=$objPHPExcel->createSheet();
$index[$i]->setTitle(’sheetname’.$i);
//设置单元格的值
$index[$i]->setCellValue(‘A1′, ‘test’);
$number = 1;
foreach ($v as $k1=>$v1){
$number++;
$index[$i]->setCellValueExplicit(‘A’.$number, ”.$v1['data'].”);
}
}
$i++;
}
//直接输出到浏览器
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
header(“Pragma: public”);
header(“Expires: 0″);
header(“Cache-Control:must-revalidate, post-check=0, pre-check=0″);
header(“Content-Type:application/force-download”);
header(“Content-Type:application/vnd.ms-execl”);
header(“Content-Type:application/octet-stream”);
header(“Content-Type:application/download”);;
header(‘Content-Disposition:attachment;filename=”excel’.xls”‘);
header(“Content-Transfer-Encoding:binary”);
$objWriter->save(‘php://output’);
