How to set auto height in phpexcel?

I am using phpexcel to generate excel document with PHP.

the question is, how to make auto height row using phpexcel? many thanks :)

Solution 1:

$excel->getActiveSheet()->getRowDimension(1)->setRowHeight(-1);

Should set the row height to 'auto' for row 1.

Solution 2:

$excel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(-1);

Solution 3:

To change height of all rows to auto you can do:

foreach($xls->getActiveSheet()->getRowDimensions() as $rd) { 
    $rd->setRowHeight(-1); 
}

Solution 4:

You can set it by using following code,

$objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(-1);
$objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setWrapText(true);