导入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');