To establish a consistent row height for all rows in PHP Spreadsheet, you can use the following code:
// Set a default row height
$sheet->getDefaultRowDimension()->setRowHeight(20);
// Loop through all rows and set the row height
foreach ($sheet->getRowIterator() as $row) {
$row->getWorksheet()->getRowDimension($row->getRowIndex())->setRowHeight(20);
}
This code sets a default row height of 20 and then loops through all the rows in the worksheet, setting the row height to the default value. This ensures that all rows have the same height.
Asked: 2023-06-25 18:17:40 +0000
Seen: 10 times
Last updated: Jun 25 '23