php 自动合并excel,使用php合并Excel文件

$inputFileType1 = 'Excel2007';

$inputFileName1 = 'inputData1.xlsx';

$inputFileType2 = 'Excel5';

$inputFileName2 = 'inputData2.xls';

$outputFileType = 'Excel5';

$outputFileName = 'outputData.xls';

// Load the first workbook (an xlsx file)

$objPHPExcelReader1 = PHPExcel_IOFactory::createReader($inputFileType1);

$objPHPExcel1 = $objPHPExcelReader1->load($inputFileName1);

// Load the second workbook (an xls file)

$objPHPExcelReader2 = PHPExcel_IOFactory::createReader($inputFileType2);

$objPHPExcel2 = $objPHPExcelReader2->load($inputFileName2);

// Merge the second workbook into the first

$objPHPExcel2->getActiveSheet()->setTitle('Unique worksheet name');

$objPHPExcel1->addExternalSheet($objPHPExcel2->getActiveSheet());

// Save the merged workbook under a new name (could save under the original name)

// as an xls file

$objPHPExcelWriter = PHPExcel_IOFactory::createWriter($objPHPExcel1,$outputFileType);

$objPHPExcelWriter->save($outputFileName);