php_excel07- how to fix min heigth and mak to grow height based on the contents of a cell

Question

I have to Export data to xlsx, where the exported file should be in a pre defined format. Becoz of these i am using "PHPexcel". And i created a template of some format with each row with some specified height.

Actually in each cell i will be writing the data dynamically. so if the text is larger, then the row height in not increased.

So is ther anyway so tat row height is increased to fit the cell text.

Answer 1

To set a row to autofit:

$objPHPExcel->getActiveSheet()->getRowDimension(10)->setAutoSize(true);

And then set the individual cells to allow wrapping

$objPHPExcel->getActiveSheet()->getStyle('A10:D10')->getAlignment()->setWrapText(true);