load($file);
self::assertSame('', $spreadsheet->getProperties()->getTitle());
$writer = new Html($spreadsheet);
$writer->setUseInlineCss(true);
$html = $writer->generateHTMLAll();
self::assertStringContainsString('Sheet1', $html);
self::assertStringContainsString('| C1 | ', $html);
$writer->setUseInlineCss(false);
$html = $writer->generateHTMLAll();
self::assertStringContainsString('C1 | ', $html);
$spreadsheet->disconnectWorksheets();
}
public function testHideSomeGridlines(): void
{
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->fromArray(
[
[1, 2, 3, 4, 5, 6],
[7, 8, 9, 10, 11, 12],
[17, 18, 19, 20, 21, 22],
[27, 28, 29, 30, 31, 32],
[37, 38, 39, 40, 41, 42],
]
);
$sheet->getStyle('B2:D4')->getBorders()->applyFromArray(
[
'allBorders' => [
'borderStyle' => Border::BORDER_NONE,
'color' => ['rgb' => '808080'],
],
],
);
$writer = new Html($spreadsheet);
$writer->setUseInlineCss(true);
$html = $writer->generateHTMLAll();
self::assertStringContainsString('7 | ', $html);
self::assertStringContainsString('19 | ', $html);
$spreadsheet->disconnectWorksheets();
}
}