PHPExcel多个表修改插入新的数据

导入phpexcel

require_once './Excel/Classes/PHPExcel/IOFactory.php';
$filePath = './simple.xls';
$objPHPExcel = PHPExcel_IOFactory::load($filePath);
$sheet = $objPHPExcel->getSheet(0); // 读取第一個工作表

取得当前文档的行数

$highestRow = $sheet->getHighestRow(); // 取得总行数

插入新数据

//第一个工作表
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A'.$highestRow, '新数据');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B'.$highestRow, '新数据');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C'.$highestRow, '新数据');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D'.$highestRow, '新数据');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('E'.$highestRow, '新数据');

//第二个工作表
$objPHPExcel->setActiveSheetIndex(1)->setCellValue('A'.$highestRow, '新数据');
$objPHPExcel->setActiveSheetIndex(1)->setCellValue('B'.$highestRow, '新数据');
$objPHPExcel->setActiveSheetIndex(1)->setCellValue('C'.$highestRow, '新数据');

//以此类推下去.....
//保存文件

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');//在linux 使用Excel2007可能会报permission denied之类 改成Excel5就没事了
$objWriter->save('simple.xls');