| 1 |
<?php |
| 2 |
|
| 3 |
use PhpOffice\PhpSpreadsheet\IOFactory; |
| 4 |
|
| 5 |
require __DIR__ . '/../Header.php'; |
| 6 |
|
| 7 |
$spreadsheet = require __DIR__ . '/../templates/sampleSpreadsheet.php'; |
| 8 |
|
| 9 |
// Write temporary file |
| 10 |
$filename = $helper->getTemporaryFilename('xls'); |
| 11 |
$writer = IOFactory::createWriter($spreadsheet, 'Xls'); |
| 12 |
$callStartTime = microtime(true); |
| 13 |
$writer->save($filename); |
| 14 |
$helper->logWrite($writer, $filename, $callStartTime); |
| 15 |
|
| 16 |
// Read Xls file |
| 17 |
$callStartTime = microtime(true); |
| 18 |
$spreadsheet = IOFactory::load($filename); |
| 19 |
$helper->logRead('Xls', $filename, $callStartTime); |
| 20 |
|
| 21 |
// Save |
| 22 |
$helper->write($spreadsheet, __FILE__); |
| 23 |
|
