getActiveSheet();
$sheet1->setShowGridlines(false);
$sheet1->setPrintGridlines(false);
$sheet1->fromArray([
[11, 12, 13],
[14, 15, 16],
]);
$sheet2 = $spreadsheet->createSheet();
$sheet2->setShowGridlines(false);
$sheet2->setPrintGridlines(true);
$sheet2->fromArray([
[21, 22, 23],
[24, 25, 26],
]);
$sheet3 = $spreadsheet->createSheet();
$sheet3->setShowGridlines(true);
$sheet3->setPrintGridlines(false);
$sheet3->fromArray([
[31, 32, 33],
[34, 35, 36],
]);
$sheet4 = $spreadsheet->createSheet();
$sheet4->setShowGridlines(true);
$sheet4->setPrintGridlines(true);
$sheet4->fromArray([
[41, 42, 43],
[44, 45, 46],
]);
$writer = new HtmlWriter($spreadsheet);
$writer->writeAllSheets();
$writer->setUseInlineCss(true);
$html = $writer->generateHtmlAll();
self::assertStringContainsString(
'| 11 | ',
$html,
'neither gridlines nor gridlinesp'
);
self::assertStringContainsString(
'21 | ',
$html,
'gridlinesp without gridlines'
);
self::assertStringContainsString(
'31 | ',
$html,
'gridlines without gridlinesp'
);
self::assertStringContainsString(
'41 | ',
$html,
'gridlines and gridlinesp'
);
$count = substr_count($html, 'page-break-before');
self::assertSame(1, $count);
$spreadsheet->disconnectWorksheets();
}
public function testGridlinesCss(): void
{
$spreadsheet = new Spreadsheet();
$sheet1 = $spreadsheet->getActiveSheet();
$sheet1->setShowGridlines(false);
$sheet1->setPrintGridlines(false);
$sheet1->fromArray([
[11, 12, 13],
[14, 15, 16],
]);
$sheet2 = $spreadsheet->createSheet();
$sheet2->setShowGridlines(false);
$sheet2->setPrintGridlines(true);
$sheet2->fromArray([
[21, 22, 23],
[24, 25, 26],
]);
$sheet3 = $spreadsheet->createSheet();
$sheet3->setShowGridlines(true);
$sheet3->setPrintGridlines(false);
$sheet3->fromArray([
[31, 32, 33],
[34, 35, 36],
]);
$sheet4 = $spreadsheet->createSheet();
$sheet4->setShowGridlines(true);
$sheet4->setPrintGridlines(true);
$sheet4->fromArray([
[41, 42, 43],
[44, 45, 46],
]);
$writer = new HtmlWriter($spreadsheet);
$writer->writeAllSheets();
$writer->setUseInlineCss(false);
$html = $writer->generateHtmlAll();
self::assertStringContainsString(
"",
$html,
'neither gridlines nor gridlinesp 1'
);
self::assertStringContainsString(
'| 11 | ',
$html,
'neither gridlines nor gridlinesp 2'
);
self::assertStringContainsString(
"",
$html,
'gridlinesp without gridlines 1'
);
self::assertStringContainsString(
'| 21 | ',
$html,
'gridlinesp without gridlines 2'
);
self::assertStringContainsString(
"",
$html,
'gridlines without gridlinesp 1'
);
self::assertStringContainsString(
'| 31 | ',
$html,
'gridlines without gridlinesp 2'
);
self::assertStringContainsString(
"",
$html,
'gridlines and gridlinesp 2'
);
self::assertStringContainsString(
'| 41 | ',
$html,
'gridlines and gridlinesp 2'
);
$count = substr_count($html, 'page-break-before');
self::assertSame(1, $count);
$spreadsheet->disconnectWorksheets();
}
}