getActiveSheet(); $target = 'A2:B5'; $sheet->mergeCells($target); $sheet->setCellValue('A2', 'Planning'); $sheet->getStyle($target)->applyFromArray([ 'borders' => [ 'outline' => [ 'borderStyle' => Border::BORDER_HAIR, 'color' => ['rgb' => 'FF0000'], ], ], ]); $sheet->setSelectedCells('D1'); $sheet->setCellValue('D1', 'Edge'); $sheet->setCellValue('D5', 'Edge'); $sheet->setShowGridlines(false); $writer = new Tcpdf($spreadsheet); $html = $writer->generateHtmlAll(); self::assertSame(1, preg_match('/ colspan="2" rowspan="4" style="vertical-align:bottom; border-bottom:1px solid #FF0000 !important; border-top:1px solid #FF0000 !important; border-left:1px solid #FF0000 !important; border-right:1px solid #FF0000 !important; color:#000000;[^>]+/', $html)); $spreadsheet->disconnectWorksheets(); } }