| 1 |
<?php |
| 2 |
|
| 3 |
use PhpOffice\PhpSpreadsheet\IOFactory; |
| 4 |
|
| 5 |
require __DIR__ . '/../Header.php'; |
| 6 |
|
| 7 |
$helper->log('Load MergeBook1 from Xlsx file'); |
| 8 |
$filename1 = __DIR__ . '/../templates/43mergeBook1.xlsx'; |
| 9 |
$callStartTime = microtime(true); |
| 10 |
$spreadsheet1 = IOFactory::load($filename1); |
| 11 |
$helper->logRead('Xlsx', $filename1, $callStartTime); |
| 12 |
|
| 13 |
$helper->log('Load MergeBook2 from Xlsx file'); |
| 14 |
$filename2 = __DIR__ . '/../templates/43mergeBook2.xlsx'; |
| 15 |
$callStartTime = microtime(true); |
| 16 |
$spreadsheet2 = IOFactory::load($filename2); |
| 17 |
$helper->logRead('Xlsx', $filename2, $callStartTime); |
| 18 |
|
| 19 |
foreach ($spreadsheet2->getSheetNames() as $sheetName) { |
| 20 |
$sheet = $spreadsheet2->getSheetByName($sheetName); |
| 21 |
$sheet->setTitle($sheet->getTitle() . ' copied'); |
| 22 |
$spreadsheet1->addExternalSheet($sheet); |
| 23 |
} |
| 24 |
|
| 25 |
// Save |
| 26 |
$helper->write($spreadsheet1, __FILE__); |
| 27 |
|
