Converting from excel to pdf in PHPSpreadsheet without ruining design/style

user_4544426 0
Viewed 3722

I tried exporting my PHPSpreadsheet as a PDF. What I did was setting the header like:

header("Content-Disposition: attachment;filename=hello world.pdf");

and the $writer like this:

$writer = new \PhpOffice\PhpSpreadsheet\Writer\Pdf\Mpdf($spreadsheet);
$writer->save("php://output");

The rest of my code stays the same as for exporting as XLSX. It seems to not like the styling commands and also imports the cells where there is no text. An example of how I create info in a cell for Excel is like this:

$sheet->setCellValue('A16', $activitiesCount)->getStyle('A16');
$sheet->getStyle('A16')->getFill()->setFillType(Fill::FILL_SOLID);
$sheet->getStyle('A16')->getFill()->getStartColor()->setARGB('d9e6fc');

Here is the original in excel:

enter image description here

This one exports fine if I save it as PDF directly from excel itself. But when I try to do it with my code, this seems to be the result:

enter image description here

As you can see its getting really messy. Does it mean I have to program it in a another way for PDF? I thought it was going to be easy to change between those to.

PS: Dont mind the name differences between the pictures. I tested something in DB to see how it scales when name is really long. It wasnt pretty, let me tell you.

phpspreadsheet spreadsheet excel pdf-generation php
1 Answers

This isn't much of an answer, but if you read the documentation you will see a note:

Please note that PDF file format has some limits regarding to styling cells, number formatting, ...

You might have better luck trying a library other than mPDF. From the same page:

The different libraries have different strengths and weaknesses. Some generate better formatted output than others, some are faster or use less memory than others, while some generate smaller .pdf files

user_12552890
Related