Some tips for PhpSpreadsheet

tips.php

<?php
    use PhpOffice\PhpSpreadsheet\Spreadsheet;
    use PhpOffice\PhpSpreadsheet\IOFactory;
    use PhpOffice\PhpSpreadsheet\Style\Alignment;
    use PhpOffice\PhpSpreadsheet\Style\NumberFormat;

    const FORMAT_CODE = '_(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)';

    # set row auto height
    $worksheet->getRowDimension($rowDetail)->setRowHeight(-1);

    # format cell as a number
    $worksheet->getStyle([CELL])->getNumberFormat()->setFormatCode(self::FORMAT_CODE);

    # set bold
    $worksheet->getStyle([CELL])->getFont()->setBold(true|false);

    #set text align
    $worksheet->getStyle([CELL])->getAlignment()->setHorizontal(Alignment::HORIZONTAL_CENTER);