I recently needed to generate an excel file containing 3 worksheets.
When all the work was done, "hurray", the project manager tells me he'd now prefer it in PDF.
Hopefully, PHPExcel allows you to generate PDF so that's what i did : just changed the format.
Although i have one issue : i have 5 columns each one containing text. This text can be from time to time quite long so the PDF version doesn't print all the collumns. (last one is missing cause it's outside the page)
Is there anyway i can configure my collumns to "fit to the page" ?
For now, i configured my columns with:
Plus, it seems cell borders aren't working for the PDF writer (have them under Excel5, not on PDF) . Is it normal ?
I'm using version 1.7.1.