getActiveSheet(); $target = 'A1:A2'; $sheet->mergeCells($target); $sheet->setCellValue('A1', 'Planning'); $sheet->setSelectedCells('D1'); $sheet->setCellValue('A4', 'Edge'); $sheet->setShowGridlines(false); $writer = new Tcpdf($spreadsheet); $writer->setLineEnding("\n"); $html = $writer->generateHtmlAll(); $html = (string) preg_replace('/^\s+/m', '', $html); $expectedArray = [ '', 'Planning', // row 1 has cell '', '', ' ', // row 2 with only merged cell '', '', ' ', // row 3 no cell '', '', 'Edge', // row 4 has cell '', ]; $expectedString = implode("\n", $expectedArray); self::assertStringContainsString($expectedString, $html); $spreadsheet->disconnectWorksheets(); } }