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 :)

score 74 · Accepted Answer · answered May 19 '11 at 06:35

74

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

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

answered May 19 '11 at 06:35

pkavanagh

1,036
9
4

1

Any idea how to set it for the entire sheet? – eddy147 Jan 30 '12 at 08:14
10

@eddy147 - `foreach($xls->getActiveSheet()->getRowDimensions() as $rd) { $rd->setRowHeight(-1); }` – Kamil Szot Jul 03 '12 at 11:15
$excel->getActiveSheet()->getRowDimension( 1 )->setRowHeight( 30 ); working in libreoffice calc. – kodmanyagha Jul 16 '17 at 11:22

score 56 · Answer 2 · edited Feb 05 '16 at 10:02

56

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

edited Feb 05 '16 at 10:02

Bora

10,529
5
43
73

answered Mar 14 '14 at 04:04

Dhaval

569
4
5

4

Thanks! That saved me from having to write a loop. :) – iavery Mar 20 '14 at 16:39
1

Wow ! It's really what I'm looking for – realtebo Jul 03 '14 at 07:04
@Dhaval Maybe you can help me. Look at this : https://stackoverflow.com/questions/56469303/how-do-i-make-automatic-height-row-based-on-content-in-the-maatwebsite-version-3 – moses toh Jun 06 '19 at 02:47

score 22 · Answer 3 · answered Jul 03 '12 at 11:14

22

To change height of all rows to auto you can do:

foreach($xls->getActiveSheet()->getRowDimensions() as $rd) { 
    $rd->setRowHeight(-1); 
}

answered Jul 03 '12 at 11:14

Kamil Szot

17,436
6
62
65

Maybe you can help me. Look at this : https://stackoverflow.com/questions/56469303/how-do-i-make-automatic-height-row-based-on-content-in-the-maatwebsite-version-3 – moses toh Jun 06 '19 at 02:48

score 5 · Answer 4 · answered Jan 10 '17 at 10:06

5

You can set it by using following code,

$objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(-1);
$objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setWrapText(true);

answered Jan 10 '17 at 10:06

Vivek Parmar

773
1
10
26

How to set auto height in phpexcel?

4 Answers4

Linked