CODEWITHSUNDEEP
phpphpexcel
sandeep
sandeep

Reputation: 2882

php_excel: Customize the heigth row

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.

Upvotes: 2

Views: 2939

Answers (1)

maggix
maggix

Reputation: 3278

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

Upvotes: 3

Related Questions