set row height for all rows using phpspreadsheet

Question

Default row height in excel is -1 which show 15 in excel.This row height automatically resize to 15.75 after add content.So, I set new default row height,15 for all rows. Still, row height getting auto resize. Then, I try to set row height for all rows from $sheet->getRowDimensions(). There is no content in $sheet->getRowDimensions(). So, $rd->setRowHeight(15) does not take effect.

$default_rowdimensions  =$sheet->getDefaultRowDimension();
$set_newdefaultrowheight=$sheet->getDefaultRowDimension()->setRowHeight(15);

$rowdimension = $sheet->getRowDimensions();
echo '<pre>;
var_dump($rowdimension);
echo '</pre>';
foreach($rowdimension  as $rd) 
{ 
    $rd->setRowHeight(15); 
}

Is there any other ways to set row height for all rows before write to excel.

Thanks in advance.

Shouldn't this line `$set_newdefaultrowheight=$sheet->getDefaultRowDimension()->setRowHeight(15);` be `$set_newdefaultrowheight=$sheet->setRowHeight(15);`? — Dave, Apr 16 '19 at 08:25
no, `$set_newdefaultrowheight=$sheet->getDefaultRowDimension()->setRowHeight(15);`is the proper code to set default row height. — Premlatha, Apr 16 '19 at 09:27

score 4 · Answer 1 · answered Apr 07 '22 at 12:32

4

For PhpSpreadSheet, the correct way to archive this is :

$spreadsheet->getActiveSheet()->getRowDimension('2')->setRowHeight(26);

Where 2 is the number of row and 26 is the height.

answered Apr 07 '22 at 12:32

Ale DC

1,646
13
20

score 3 · Answer 2 · answered Jul 07 '21 at 03:26

3

Set the default row height with:

$sheet->getDefaultRowDimension()->setRowHeight(15);

answered Jul 07 '21 at 03:26

LF00

27,015
29
156
295

What if I wanted to change only for one row? – Ayenew Yihune Dec 16 '21 at 13:40
Looks like this works: $sheet->getRowDimension('10')->setRowHeight(15); – Ayenew Yihune Dec 16 '21 at 13:42

score 0 · Answer 3 · edited Nov 10 '22 at 10:19

0

Here you go Brother.

    // Assuming you have 50 rows or 100 rows above to format
    $a = 50; 
    for($i = 0; $i<$a;$i++){
    $spreadsheet->getActiveSheet()->getRowDimension($i)->setRowHeight(14.25);   
    }
    you can use this as shown above my $a variable assigned 50 rows;

edited Nov 10 '22 at 10:19

Thomas Smyth - Treliant

4,993
6
25
36

answered Oct 30 '22 at 02:39

GALON MARKJAYPEE

1
1

score 0 · Answer 4 · answered Mar 29 '23 at 11:29

here try this. it will make every used cell (cell with value in it) height to 15.

sheet = $spreadsheet->getActiveSheet();
foreach ($sheet->getRowIterator() as $row) {
            $sheet->getRowDimension($row->getRowIndex())->setRowHeight(15);
        }

set row height for all rows using phpspreadsheet

4 Answers4