Php_excel07- how to fix min heigth and mak for height growth based on cell contents

Question

I need to export data to xlsx where the exported file must be in a predefined format. Becoz of these I use "PHPexcel". And I created a template of some format with each line with a certain height.

In fact, in each cell I will dynamically record data. therefore, if the text is larger, the line height does not increase.

So this is the case, so that the height of the tat row is increased to fit the cell text.

Answer 1

To set the line for auto tuning:

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

And then set individual cells to enable wrapper

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