I have some cells with text, in which strings are transferred by words. I need to set 'auto height' to the rows, but it does not work.
Below is my code:
$this->objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight('-1');
Asked
Active
Viewed 2,098 times
3
DhruvJoshi
- 17,041
- 6
- 41
- 60
Vladimir Glechikov
- 131
- 1
- 8
-
Did you try this ? $excel->getActiveSheet()->getRowDimension(1)->setRowHeight(-1); – Techidiot Sep 23 '15 at 10:03
-
Refer this - > http://stackoverflow.com/questions/6054444/how-to-set-auto-height-in-phpexcel – Techidiot Sep 23 '15 at 10:04
-
Yes, I have tryed this but it exactly doesn't work. – Vladimir Glechikov Sep 23 '15 at 10:13
-
1Set the cell styles to wrap, otherwise the cell height will just be the height of a single line: http://stackoverflow.com/questions/3881623/php-excel07-how-to-fix-min-heigth-and-mak-to-grow-height-based-on-the-contents – Mark Baker Sep 23 '15 at 11:42