How to set auto height in phpexcel?

php phpexcel
bungdito picture bungdito · May 19, 2011 · Viewed 80.2k times · Source

I am using phpexcel to generate excel document with PHP.

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

Answer

pkavanagh picture pkavanagh · May 19, 2011 
$excel->getActiveSheet()->getRowDimension(1)->setRowHeight(-1);

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

Related questions

How to use phpexcel to read data and insert into database?

I have a php application where I want to read data from excel, Insert into database and then generate pdf reports for specific users. I searched a lot but nothing specific given about both things.

Read More
PHPExcel auto size column width

I'm trying to auto size the columns of my sheet. I'm writing the file and in the end I try to resize all of my columns. // Add some data $objPHPExcel->setActiveSheetIndex(0) ->setCellValue('B1', 'test1111111111111111111111') -&…

Read More
phpexcel to download

hello i am new to phpexcel, and i was wondering if there is some way send the excel i have created to the clients download without saving it on my server or to delete it right after he downloads it …

Read More