Convert excel file to pdf file

Apr 15, 2010 at 1:22 AM

Hi all,

How is it going?

I made one excel report file which has got 5 tabs at the bottom by using php, but my client wants report as a pdf file rather than excel file so I changed objWriter like as below

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'PDF');

and I changed file format as pdf, then I can see the report as pdf file but it shows only first tab contents on pdf file.

How can I show all tabs' contents? and I would like to do page break for each tab as well.

Also when I open a pdf report file, then I found out that image and text are too big, so some stuff is cut at right side, for that I would like to fix that problem too.

I need your help guys! Please help me out at this stage.

I need to fix this asap.

 

Thanks

Developer
Apr 20, 2010 at 3:43 AM

To write all sheets:

$writer = PHPExcel_IOFactory::createWriter($excel, 'PDF');
$writer->writeAllSheets();
$writer->save('write.pdf');