| 1 |
<?php |
| 2 |
|
| 3 |
use PhpOffice\PhpSpreadsheet\IOFactory; |
| 4 |
use PhpOffice\PhpSpreadsheet\Writer\Xlsx; |
| 5 |
|
| 6 |
require __DIR__ . '/../Header.php'; |
| 7 |
|
| 8 |
// Create temporary file that will be read |
| 9 |
$sampleSpreadsheet = require __DIR__ . '/../templates/chartSpreadsheet.php'; |
| 10 |
$filename = $helper->getTemporaryFilename(); |
| 11 |
$writer = new Xlsx($sampleSpreadsheet); |
| 12 |
$writer->save($filename); |
| 13 |
|
| 14 |
$helper->log('Load from Xlsx file'); |
| 15 |
$reader = IOFactory::createReader('Xlsx'); |
| 16 |
$reader->setIncludeCharts(true); |
| 17 |
$spreadsheet = $reader->load($filename); |
| 18 |
|
| 19 |
$helper->log('Update cell data values that are displayed in the chart'); |
| 20 |
$worksheet = $spreadsheet->getActiveSheet(); |
| 21 |
$worksheet->fromArray( |
| 22 |
[ |
| 23 |
[50 - 12, 50 - 15, 50 - 21], |
| 24 |
[50 - 56, 50 - 73, 50 - 86], |
| 25 |
[50 - 52, 50 - 61, 50 - 69], |
| 26 |
[50 - 30, 50 - 32, 50], |
| 27 |
], |
| 28 |
null, |
| 29 |
'B2' |
| 30 |
); |
| 31 |
|
| 32 |
// Save Excel 2007 file |
| 33 |
$filename = $helper->getFilename(__FILE__); |
| 34 |
$writer = IOFactory::createWriter($spreadsheet, 'Xlsx'); |
| 35 |
$writer->setIncludeCharts(true); |
| 36 |
$callStartTime = microtime(true); |
| 37 |
$writer->save($filename); |
| 38 |
$helper->logWrite($writer, $filename, $callStartTime); |
| 39 |
|
