| 12345678910111213141516171819202122232425 |
- <?php
- use PhpOffice\PhpSpreadsheet\Spreadsheet;
- use PhpOffice\PhpSpreadsheet\Writer\Pdf\Mpdf;
- require __DIR__ . '/../Header.php';
- // Issue 2432 - styles were too large to fit in first Mpdf chunk, causing problems.
- $spreadsheet = new Spreadsheet();
- $sheet = $spreadsheet->getActiveSheet();
- $counter = 0;
- $helper->log('Populate spreadsheet');
- for ($row = 1; $row < 501; ++$row) {
- $sheet->getCell("A$row")->setValue(++$counter);
- // Add many styles by using slight variations of font color for each.
- $sheet->getCell("A$row")->getStyle()->getFont()->getColor()->setRgb(sprintf('%06x', $counter));
- $sheet->getCell("B$row")->setValue(++$counter);
- $sheet->getCell("C$row")->setValue(++$counter);
- }
- $helper->log('Write to Mpdf');
- $writer = new Mpdf($spreadsheet);
- $filename = $helper->getFileName('21c_Pdf_mpdf.xlsx', 'pdf');
- $writer->save($filename);
- $helper->log("Saved $filename");
|