php导出excel过程中设置sheet名称。
$phpEx = new \PHPExcel();
foreach ( $arrOrg as $j=>$or )
{
$phpEx->createSheet( $j );
$phpEx->setactivesheetindex( $j )->setTitle( $or[ 'sheet' ] );
$phpEx->getactivesheet( $j )->setcellvalue( 'A1', 'SPU' );
$phpEx->getactivesheet( $j )->setcellvalue( 'B1', 'NAME' );
$phpEx->getactivesheet( $j )->setcellvalue( 'C1', 'PRICE' );
foreach ( $or[ 'list' ] as $i=>$row )
{
$i = $i+2;
$phpEx->getactivesheet( $j )->setcellvalue( 'A'.$i, NULL );
$phpEx->getactivesheet( $j )->setcellvalue( 'B'.$i, $row[ 'name' ] );
$phpEx->getactivesheet( $j )->setcellvalue( 'C'.$i, $row[ 'price' ]);
}
}
$obwrite = \PHPExcel_IOFactory::createWriter( $phpEx, 'Excel2007');
$obwrite->save( storage_path( 'logs/mulit_sheet.xls' ) );
如上代码所示。 可创建excel时加上当前工作组(Worksheet)
内部数据结构示例:
成功示例: