php 多sheet

$datas = json_decode($datas,true)['indexConfigInsert'];
$datas2 = json_decode($datas,true)['linkConfigInsert'];
$datas3 = json_decode($datas,true)['loopGroupInsert'];

$fileName .= "-" . date("YmdHis") . ".xls";
$objPHPExcel = new PHPExcel();
//这里sheet1开始
$objPHPExcel->setActiveSheetIndex(0); // 设置活动单指数到第一个表,所以Excel打开这是第一个表
$objPHPExcel->getActiveSheet(0)->setTitle("公众号配置");
//$key = ord("A"); // 设置表头
//foreach ($headArr as $v) {
//    $colum = chr($key);
//    $objPHPExcel->setActiveSheetIndex(0)->setCellValue($colum . '1', $v);
//    $key += 1;
//}
//超过z下面方法
foreach ($headArr as $i => $v) {
    $k = \PHPExcel_Cell::stringFromColumnIndex($i);
    $objPHPExcel->setActiveSheetIndex()->setCellValue($k . '1', $v);
}
$column = 2;
foreach ($datas as $rows) { // 行写入
    foreach (array_values($rows) as $ki => $value) { // 列写入
        $k=\PHPExcel_Cell::stringFromColumnIndex($ki);
        $objPHPExcel->setActiveSheetIndex()->setCellValue($k . $column, $this->wxNickNameFormat($value));
    }
    $column++;
}

//这里sheet2开始
$objPHPExcel->createSheet();
$objPHPExcel->setActiveSheetIndex(1); // 设置活动单指数到第2个表,所以Excel打开这是第2个表
$objPHPExcel->getActiveSheet(1)->setTitle("公众号配置");
foreach ($headArr2 as $i => $v) {
    $k = \PHPExcel_Cell::stringFromColumnIndex($i);
    $objPHPExcel->setActiveSheetIndex()->setCellValue($k . '1', $v);
}
$column = 2;
foreach ($datas2 as $rows) { // 行写入
    foreach (array_values($rows) as $ki => $value) { // 列写入
        $k=\PHPExcel_Cell::stringFromColumnIndex($ki);
        $objPHPExcel->setActiveSheetIndex()->setCellValue($k . $column, $this->wxNickNameFormat($value));
    }
    $column++;
}

//这里sheet3开始
$objPHPExcel->createSheet();
$objPHPExcel->setActiveSheetIndex(2); // 设置活动单指数到第3个表,所以Excel打开这是第3个表
$objPHPExcel->getActiveSheet(2)->setTitle("循环组");
foreach ($headArr3 as $i => $v) {
    $k = \PHPExcel_Cell::stringFromColumnIndex($i);
    $objPHPExcel->setActiveSheetIndex()->setCellValue($k . '1', $v);
}
$column = 2;
foreach ($datas3 as $rows) { // 行写入
    foreach (array_values($rows) as $ki => $value) { // 列写入
        $k=\PHPExcel_Cell::stringFromColumnIndex($ki);
        $objPHPExcel->setActiveSheetIndex()->setCellValue($k . $column, $this->wxNickNameFormat($value));
    }
    $column++;
}

$fileName = iconv("utf-8", "gb2312", $fileName); // 重命名表
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();