使用PHP将数据添加到excel文件中的新行

require_once 'PHPExcel/Classes/PHPExcel.php';

$objPHPExcel = PHPExcel_IOFactory::load('example.xlsx');

$objPHPExcel->setActiveSheetIndex(0);
$sheet = $objPHPExcel->getActiveSheet();

$data = array(
    array('John', 'Doe', 'john@example.com'),
    array('Jane', 'Smith', 'jane@example.com'),
);

$lastRow = $sheet->getHighestRow();
$newRow = $lastRow + 1;

foreach ($data as $row) {
    $column = 'A';
    foreach ($row as $cell) {
        $sheet->setCellValue($column.$newRow, $cell);
        $column++;
    }
    $newRow++;
}

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