setRowHeight from getDefaultRowDimension not working with data has wrapText

[ckan719]

I use $sheetEdit->getDefaultRowDimension()->setRowHeight(15); but it is not working when data has wrapText, so i use

for ($row = 1; $row <= $highestRow; $row++) {
    $sheetEdit->getRowDimension($row)->setRowHeight(15);
}

as an alternative. But it is very memory consuming if the number of rows is large. Is there any solution to fix this problem?

[chethan7032]

we can just Disable automatic row height adjustment with wrapText as below

$sheetEdit->getStyle($sheetEdit->calculateWorksheetDimension())
->getAlignment()
->setWrapText(false);
$sheetEdit->getDefaultRowDimension()->setRowHeight(15);

[ckan719]

we can just Disable automatic row height adjustment with wrapText as below

$sheetEdit->getStyle($sheetEdit->calculateWorksheetDimension()) ->getAlignment() ->setWrapText(false); $sheetEdit->getDefaultRowDimension()->setRowHeight(15);

Thanks. But my data must be keep wrapText. So can't use option setWrapText(false)