21c_Pdf.php 900 B

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