将对象数组添加到PHPExcel模板

$objPHPExcel = new PHPExcel();

$objReader = PHPExcel_IOFactory::createReader('Excel2007');
$objPHPExcel = $objReader->load('template.xlsx');

$sheet = $objPHPExcel->getActiveSheet();

$data = array(
    array('Name', 'Age', 'Email'),
    array('John Doe', 25, 'john@example.com'),
    array('Jane Smith', 30, 'jane@example.com'),
);

$row = 1;
foreach ($data as $rowData) {
    $col = 0;
    foreach ($rowData as $value) {
        $sheet->setCellValueByColumnAndRow($col, $row, $value);
        $col++;
    }
    $row++;
}

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('output.xlsx');