|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
use PhpOffice\PhpSpreadsheet\Worksheet\PageSetup; |
|
4
|
|
|
use PhpOffice\PhpSpreadsheet\Writer\Pdf\Dompdf; |
|
5
|
|
|
use PhpOffice\PhpSpreadsheet\Writer\Pdf\Mpdf; |
|
6
|
|
|
use PhpOffice\PhpSpreadsheet\Writer\Pdf\Tcpdf; |
|
7
|
|
|
|
|
8
|
|
|
function replaceBody(string $html): string |
|
9
|
|
|
{ |
|
10
|
|
|
$lorem = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'; |
|
11
|
|
|
$bodystring = '~<body>.*</body>~ms'; |
|
12
|
|
|
$bodyrepl = <<<EOF |
|
13
|
|
|
<body> |
|
14
|
|
|
<h1>Serif</h1> |
|
15
|
|
|
<p style='font-family: serif; font-size: 12pt;'>$lorem</p> |
|
16
|
|
|
<h1>Sans-Serif</h1> |
|
17
|
|
|
<p style='font-family: sans-serif; font-size: 12pt;'>$lorem</p> |
|
18
|
|
|
<h1>Monospace</h1> |
|
19
|
|
|
<p style='font-family: monospace; font-size: 12pt;'>$lorem</p> |
|
20
|
|
|
</body> |
|
21
|
|
|
EOF; |
|
22
|
|
|
|
|
23
|
|
|
return preg_replace($bodystring, $bodyrepl, $html); |
|
24
|
|
|
} |
|
25
|
|
|
|
|
26
|
|
|
require __DIR__ . '/../Header.php'; |
|
27
|
|
|
$spreadsheet = require __DIR__ . '/../templates/sampleSpreadsheet.php'; |
|
28
|
|
|
|
|
29
|
|
|
$helper->log('Hide grid lines'); |
|
30
|
|
|
$spreadsheet->getActiveSheet()->setShowGridLines(false); |
|
31
|
|
|
|
|
32
|
|
|
$helper->log('Set orientation to landscape'); |
|
33
|
|
|
$spreadsheet->getActiveSheet()->getPageSetup()->setOrientation(PageSetup::ORIENTATION_LANDSCAPE); |
|
34
|
|
|
|
|
35
|
|
|
$helper->log('Write to Dompdf'); |
|
36
|
|
|
$writer = new Dompdf($spreadsheet); |
|
37
|
|
|
$filename = $helper->getFileName('21b_Pdf_dompdf.xlsx', 'pdf'); |
|
38
|
|
|
$writer->setEditHtmlCallback('replaceBody'); |
|
39
|
|
|
$writer->save($filename); |
|
40
|
|
|
|
|
41
|
|
|
$helper->log('Write to Mpdf'); |
|
42
|
|
|
$writer = new Mpdf($spreadsheet); |
|
43
|
|
|
$filename = $helper->getFileName('21b_Pdf_mpdf.xlsx', 'pdf'); |
|
44
|
|
|
$writer->setEditHtmlCallback('replaceBody'); |
|
45
|
|
|
$writer->save($filename); |
|
46
|
|
|
|
|
47
|
|
|
$helper->log('Write to Tcpdf'); |
|
48
|
|
|
$writer = new Tcpdf($spreadsheet); |
|
49
|
|
|
$filename = $helper->getFileName('21b_Pdf_tcpdf.xlsx', 'pdf'); |
|
50
|
|
|
$writer->setEditHtmlCallback('replaceBody'); |
|
51
|
|
|
$writer->save($filename); |
|
52
|
|
|
|
PHPOffice /
PhpSpreadsheet
