| 1 |
<?php |
| 2 |
|
| 3 |
use PhpOffice\PhpSpreadsheet\IOFactory; |
| 4 |
use PhpOffice\PhpSpreadsheet\Shared\Date; |
| 5 |
|
| 6 |
require __DIR__ . '/../Header.php'; |
| 7 |
|
| 8 |
$helper->log('Load from Xls template'); |
| 9 |
$reader = IOFactory::createReader('Xls'); |
| 10 |
$spreadsheet = $reader->load(__DIR__ . '/../templates/30template.xls'); |
| 11 |
|
| 12 |
$helper->log('Add new data to the template'); |
| 13 |
$data = [['title' => 'Excel for dummies', |
| 14 |
'price' => 17.99, |
| 15 |
'quantity' => 2, |
| 16 |
], |
| 17 |
['title' => 'PHP for dummies', |
| 18 |
'price' => 15.99, |
| 19 |
'quantity' => 1, |
| 20 |
], |
| 21 |
['title' => 'Inside OOP', |
| 22 |
'price' => 12.95, |
| 23 |
'quantity' => 1, |
| 24 |
], |
| 25 |
]; |
| 26 |
|
| 27 |
$spreadsheet->getActiveSheet()->setCellValue('D1', Date::PHPToExcel(time())); |
| 28 |
|
| 29 |
$baseRow = 5; |
| 30 |
foreach ($data as $r => $dataRow) { |
| 31 |
$row = $baseRow + $r; |
| 32 |
$spreadsheet->getActiveSheet()->insertNewRowBefore($row, 1); |
| 33 |
|
| 34 |
$spreadsheet->getActiveSheet()->setCellValue('A' . $row, $r + 1) |
| 35 |
->setCellValue('B' . $row, $dataRow['title']) |
| 36 |
->setCellValue('C' . $row, $dataRow['price']) |
| 37 |
->setCellValue('D' . $row, $dataRow['quantity']) |
| 38 |
->setCellValue('E' . $row, '=C' . $row . '*D' . $row); |
| 39 |
} |
| 40 |
$spreadsheet->getActiveSheet()->removeRow($baseRow - 1, 1); |
| 41 |
|
| 42 |
// Save |
| 43 |
$helper->write($spreadsheet, __FILE__); |
| 44 |
|
