PHPOffice / PhpSpreadsheet

    public static function getDefaultRowHeightByFont(\PhpSpreadsheet\Style\Font $font)

    {

        switch ($font->getName()) {

            case 'Arial':

                switch ($font->getSize()) {

                    case 10:

                        // inspection of Arial 10 workbook says 12.75pt ~17px

                        $rowHeight = 12.75;

                        break;

                    case 9:

                        // inspection of Arial 9 workbook says 12.00pt ~16px

                        $rowHeight = 12;

                        break;

                    case 8:

                        // inspection of Arial 8 workbook says 11.25pt ~15px

                        $rowHeight = 11.25;

                        break;

                    case 7:

                        // inspection of Arial 7 workbook says 9.00pt ~12px

                        $rowHeight = 9;

                        break;

                    case 6:

                    case 5:

                        // inspection of Arial 5,6 workbook says 8.25pt ~11px

                        $rowHeight = 8.25;

                        break;

                    case 4:

                        // inspection of Arial 4 workbook says 6.75pt ~9px

                        $rowHeight = 6.75;

                        break;

                    case 3:

                        // inspection of Arial 3 workbook says 6.00pt ~8px

                        $rowHeight = 6;

                        break;

                    case 2:

                    case 1:

                        // inspection of Arial 1,2 workbook says 5.25pt ~7px

                        $rowHeight = 5.25;

                        break;

                    default:

                        // use Arial 10 workbook as an approximation, extrapolation

                        $rowHeight = 12.75 * $font->getSize() / 10;

                        break;

                }

                break;

            case 'Calibri':

                switch ($font->getSize()) {

                }

                break;

            case 'Calibri':

                switch ($font->getSize()) {

                    case 11:

                        // inspection of Calibri 11 workbook says 15.00pt ~20px

                        $rowHeight = 15;

                        break;

                    case 10:

                        // inspection of Calibri 10 workbook says 12.75pt ~17px

                        $rowHeight = 12.75;

                        break;

                    case 9:

                        // inspection of Calibri 9 workbook says 12.00pt ~16px

                        $rowHeight = 12;

                        break;

                    case 8:

                        // inspection of Calibri 8 workbook says 11.25pt ~15px

                        $rowHeight = 11.25;

                        break;

                    case 7:

                        // inspection of Calibri 7 workbook says 9.00pt ~12px

                        $rowHeight = 9;

                        break;

                    case 6:

                    case 5:

                        // inspection of Calibri 5,6 workbook says 8.25pt ~11px

                        $rowHeight = 8.25;

                        break;

                    case 4:

                        // inspection of Calibri 4 workbook says 6.75pt ~9px

                        $rowHeight = 6.75;

                        break;

                    case 3:

                        // inspection of Calibri 3 workbook says 6.00pt ~8px

                        $rowHeight = 6.00;

                        break;

                    case 2:

                    case 1:

                        // inspection of Calibri 1,2 workbook says 5.25pt ~7px

                        $rowHeight = 5.25;

                        break;

                    default:

                        // use Calibri 11 workbook as an approximation, extrapolation

                        $rowHeight = 15 * $font->getSize() / 11;

                        break;

                }

                break;

            case 'Verdana':

                switch ($font->getSize()) {

                }

                break;

            case 'Verdana':

                switch ($font->getSize()) {

                    case 10:

                        // inspection of Verdana 10 workbook says 12.75pt ~17px

                        $rowHeight = 12.75;

                        break;

                    case 9:

                        // inspection of Verdana 9 workbook says 11.25pt ~15px

                        $rowHeight = 11.25;

                        break;

                    case 8:

                        // inspection of Verdana 8 workbook says 10.50pt ~14px

                        $rowHeight = 10.50;

                        break;

                    case 7:

                        // inspection of Verdana 7 workbook says 9.00pt ~12px

                        $rowHeight = 9.00;

                        break;

                    case 6:

                    case 5:

                        // inspection of Verdana 5,6 workbook says 8.25pt ~11px

                        $rowHeight = 8.25;

                        break;

                    case 4:

                        // inspection of Verdana 4 workbook says 6.75pt ~9px

                        $rowHeight = 6.75;

                        break;

                    case 3:

                        // inspection of Verdana 3 workbook says 6.00pt ~8px

                        $rowHeight = 6;

                        break;

                    case 2:

                    case 1:

                        // inspection of Verdana 1,2 workbook says 5.25pt ~7px

                        $rowHeight = 5.25;

                        break;

                    default:

                        // use Verdana 10 workbook as an approximation, extrapolation

                        $rowHeight = 12.75 * $font->getSize() / 10;

                        break;

                }

                break;

            default:

                // just use Calibri as an approximation

                $rowHeight = 15 * $font->getSize() / 11;