How to set auto height in phpexcel?

Question

I am using phpexcel to generate excel document with PHP.

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

Answer 1

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

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

Answer 2

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