CODEWITHSUNDEEP
phpphpexcelxlsxlsx
Carme
Carme

Reputation: 13

PHPExcel - Combine two file in one

I have two xlsx files: first.xlsx and second.xlsx, I would combine this two files in one and color the second part of the last file appended(second.xlsx). What can I do?

Upvotes: 0

Views: 3605

Answers (1)

Mark Baker
Mark Baker

Reputation: 212402

Open/load both files as two separate PHPExcel objects, and use the addExternalSheet() method to move sheets from the second PHPExcel object to the first, then colour to taste and save the first.

$objPHPExcel1 = PHPExcel_IOFactory::load("MergeBook1.xlsx");
$objPHPExcel2 = PHPExcel_IOFactory::load("MergeBook2.xlsx");

foreach($objPHPExcel2->getSheetNames() as $sheetName) {
    $sheet = $objPHPExcel2->getSheetByName($sheetName);
    $sheet->setTitle($sheet->getTitle() . ' copied');
    $objPHPExcel1->addExternalSheet($sheet);
}

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

The use of addExternalSheet() ensures that all styling, merges, etc as well as cell data is transferred over from the second workbook to the first

You can do whatever additional styling and colouring you want after the merge loop, and before saving

EDIT

If you simply want to copy data from one workbook to another, then something like:

$objPHPExcel1 = PHPExcel_IOFactory::load("MergeBook1.xlsx");
$objPHPExcel2 = PHPExcel_IOFactory::load("MergeBook2.xlsx");

$objPHPExcel1->getActiveSheet()->fromArray(
    $objPHPExcel2->getActiveSheet->toArray(),
    null,
    'A' . ($objPHPExcel1->getActiveSheet()->getHighestRow() + 1)
);

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

Upvotes: 1

Related Questions