| 1 |
<?php |
| 2 |
|
| 3 |
use PhpOffice\PhpSpreadsheet\IOFactory; |
| 4 |
use PhpOffice\PhpSpreadsheet\Worksheet\PageSetup; |
| 5 |
|
| 6 |
require __DIR__ . '/../Header.php'; |
| 7 |
$spreadsheet = require __DIR__ . '/../templates/sampleSpreadsheet.php'; |
| 8 |
|
| 9 |
$helper->log('Hide grid lines'); |
| 10 |
$spreadsheet->getActiveSheet()->setShowGridLines(false); |
| 11 |
|
| 12 |
$helper->log('Set orientation to landscape'); |
| 13 |
$spreadsheet->getActiveSheet()->getPageSetup()->setOrientation(PageSetup::ORIENTATION_LANDSCAPE); |
| 14 |
|
| 15 |
$className = \PhpOffice\PhpSpreadsheet\Writer\Pdf\Dompdf::class; |
| 16 |
$helper->log("Write to PDF format using {$className}"); |
| 17 |
IOFactory::registerWriter('Pdf', $className); |
| 18 |
|
| 19 |
// Save |
| 20 |
$helper->write($spreadsheet, __FILE__, ['Pdf']); |
| 21 |
|
