mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-24 11:58:39 +00:00
oleibman
39df9c3bcc
* Fix Some Pdf Problems Fix #1747. No support for text rotation in Pdf. That issue actually has a decent workaround, but PhpSpreadsheet should handle it on its own. Mpdf requires the proprietary text-rotate css attribute; Html and Dompdf will use the CSS3 attribute transform:rotate. Fix #1713. Some paper-size values in PhpSpreadsheet are strings, some are 2-element float arrays. Dompdf accepts strings or 4-element float arrays, where the first 2 elements are always 0. Convert the PhpSpreadsheet array accordingly before passing it to Dompdf. Some tests had been disabled when Dompdf and Tcpdf were slow to achieve PHP8 compliance. They achieved it some time ago. Re-enable the tests. * Remove Tcpdf From One Test No problem with the other tests I added it in for.
52 lines
2.0 KiB
PHP
52 lines
2.0 KiB
PHP
<?php
|
|
|
|
use PhpOffice\PhpSpreadsheet\Worksheet\PageSetup;
|
|
use PhpOffice\PhpSpreadsheet\Writer\Pdf\Dompdf;
|
|
use PhpOffice\PhpSpreadsheet\Writer\Pdf\Mpdf;
|
|
use PhpOffice\PhpSpreadsheet\Writer\Pdf\Tcpdf;
|
|
|
|
function replaceBody(string $html): string
|
|
{
|
|
$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.';
|
|
$bodystring = '~<body>.*</body>~ms';
|
|
$bodyrepl = <<<EOF
|
|
<body>
|
|
<h1>Serif</h1>
|
|
<p style='font-family: serif; font-size: 12pt;'>$lorem</p>
|
|
<h1>Sans-Serif</h1>
|
|
<p style='font-family: sans-serif; font-size: 12pt;'>$lorem</p>
|
|
<h1>Monospace</h1>
|
|
<p style='font-family: monospace; font-size: 12pt;'>$lorem</p>
|
|
</body>
|
|
EOF;
|
|
|
|
return preg_replace($bodystring, $bodyrepl, $html);
|
|
}
|
|
|
|
require __DIR__ . '/../Header.php';
|
|
$spreadsheet = require __DIR__ . '/../templates/sampleSpreadsheet.php';
|
|
|
|
$helper->log('Hide grid lines');
|
|
$spreadsheet->getActiveSheet()->setShowGridLines(false);
|
|
|
|
$helper->log('Set orientation to landscape');
|
|
$spreadsheet->getActiveSheet()->getPageSetup()->setOrientation(PageSetup::ORIENTATION_LANDSCAPE);
|
|
|
|
$helper->log('Write to Dompdf');
|
|
$writer = new Dompdf($spreadsheet);
|
|
$filename = $helper->getFileName('21b_Pdf_dompdf.xlsx', 'pdf');
|
|
$writer->setEditHtmlCallback('replaceBody');
|
|
$writer->save($filename);
|
|
|
|
$helper->log('Write to Mpdf');
|
|
$writer = new Mpdf($spreadsheet);
|
|
$filename = $helper->getFileName('21b_Pdf_mpdf.xlsx', 'pdf');
|
|
$writer->setEditHtmlCallback('replaceBody');
|
|
$writer->save($filename);
|
|
|
|
$helper->log('Write to Tcpdf');
|
|
$writer = new Tcpdf($spreadsheet);
|
|
$filename = $helper->getFileName('21b_Pdf_tcpdf.xlsx', 'pdf');
|
|
$writer->setEditHtmlCallback('replaceBody');
|
|
$writer->save($filename);
|