getActiveSheet(); $inArray = [ [1, 2, 3, 4, 5], [6, 7, 8, 9, 10], [11, 12, 13, 14, 15], [16, 17, 18, 19, 20], [21, 22, 23, 24, 25], [26, 27, 28, 29, 30], ]; $sheet->fromArray($inArray); $sheet->getPageSetup()->setPrintArea('B2:D4'); $writer = new HtmlWriter($spreadsheet); $eol = $writer->getLineEnding(); $html = $writer->generateHtmlAll(); self::assertStringContainsString( "", $html ); $expectedArray = [ '@media print {', ' table.sheet0 tr.row0 td { display:none }', ' table.sheet0 tr.row4 td { display:none }', ' table.sheet0 tr.row5 td { display:none }', ' table.sheet0 td.column0 { display:none }', ' table.sheet0 td.column4 { display:none }', '}', ]; $expectedString = implode($eol, $expectedArray); self::assertStringContainsString( $expectedString, $html ); $spreadsheet->disconnectWorksheets(); $reader = new HtmlReader(); $spreadsheet2 = $reader->loadFromString($html); $sheet2 = $spreadsheet2->getActiveSheet(); self::assertSame('B2:D4', $sheet2->getPageSetup()->getPrintArea()); self::assertSame($inArray, $sheet2->toArray(null, false, false)); $spreadsheet2->disconnectWorksheets(); } }