php_excel: Customize the heigth row.

Question

Hi,

I am using PHP_excel to export to xlsx. where im using template which has each row with a fixed height of 48. But some times the text within the cell is increases, during which row height doesn't grow even if i use wraptext().So is there any possible way to grow the height of row only in case it has more text.

Answer 1

Maybe you are trying to apply the wraptext() only to the line you expect to grow up in height?

I solved a similar problem by applying the behaviour I desired as default style for worksheet, which you set with:

$objPHPExcel->getActiveSheet()->getDefaultStyle()->getAlignment()->setWrapText(true);

You can find all the info in more detail in the PHPExcel Developer Documentation.

Hope this helps.

Regards,

Giovanni