| 1 |
<?php |
| 2 |
|
| 3 |
use PhpOffice\PhpSpreadsheet\IOFactory; |
| 4 |
use PhpOffice\PhpSpreadsheet\Writer\Xlsx; |
| 5 |
|
| 6 |
require __DIR__ . '/../Header.php'; |
| 7 |
|
| 8 |
$sampleSpreadsheet = require __DIR__ . '/../templates/sampleSpreadsheet.php'; |
| 9 |
$filename = $helper->getTemporaryFilename(); |
| 10 |
$writer = new Xlsx($sampleSpreadsheet); |
| 11 |
$callStartTime = microtime(true); |
| 12 |
$writer->save($filename); |
| 13 |
$helper->logWrite($writer, $filename, $callStartTime); |
| 14 |
|
| 15 |
$callStartTime = microtime(true); |
| 16 |
$reader = IOFactory::createReader('Xlsx'); |
| 17 |
$spreadsheet = $reader->load($filename); |
| 18 |
$helper->logRead('Xlsx', $filename, $callStartTime); |
| 19 |
$helper->log('Iterate worksheets'); |
| 20 |
foreach ($spreadsheet->getWorksheetIterator() as $worksheet) { |
| 21 |
$helper->log('Worksheet - ' . $worksheet->getTitle()); |
| 22 |
|
| 23 |
foreach ($worksheet->getRowIterator() as $row) { |
| 24 |
$helper->log(' Row number - ' . $row->getRowIndex()); |
| 25 |
|
| 26 |
$cellIterator = $row->getCellIterator(); |
| 27 |
$cellIterator->setIterateOnlyExistingCells(false); // Loop all cells, even if it is not set |
| 28 |
foreach ($cellIterator as $cell) { |
| 29 |
if ($cell !== null) { |
| 30 |
$helper->log(' Cell - ' . $cell->getCoordinate() . ' - ' . $cell->getCalculatedValue()); |
| 31 |
} |
| 32 |
} |
| 33 |
} |
| 34 |
} |
| 35 |
|
