canRead($filename)); } public function testBadHtml(): void { $filename = 'tests/data/Reader/HTML/badhtml.html'; $reader = new Html(); self::assertTrue($reader->canRead($filename)); if (method_exists($this, 'setOutputCallback')) { // The meat of this test is moved to HtmlPhpunit10Test // to run under all PhpUnit versions. $this->expectException(ReaderException::class); $reader->load($filename); } } public function testNonHtml(): void { $filename = __FILE__; $reader = new Html(); self::assertFalse($reader->canRead($filename)); $this->expectException(ReaderException::class); $reader->load($filename); } public function testInvalidFilename(): void { $reader = new Html(); self::assertEquals(0, $reader->getSheetIndex()); self::assertFalse($reader->canRead('')); } public static function providerCanReadVerySmallFile(): array { $padding = str_repeat('a', 2048); return [ [true, ' ' . $padding . ' '], [true, ' ' . $padding . ''], [true, ''], [false, ''], ]; } /** * @dataProvider providerCanReadVerySmallFile */ public function testCanReadVerySmallFile(bool $expected, string $content): void { $filename = HtmlHelper::createHtml($content); $reader = new Html(); $actual = $reader->canRead($filename); self::assertSame($expected, $actual); unlink($filename); } public function testBackgroundColorInRanding(): void { $html = '
Blue background Unknown fore/background Unknown fore/background
'; $filename = HtmlHelper::createHtml($html); $spreadsheet = HtmlHelper::loadHtmlIntoSpreadsheet($filename, true); $firstSheet = $spreadsheet->getSheet(0); $style = $firstSheet->getCell('A1')->getStyle(); self::assertEquals('FFFFFF', $style->getFont()->getColor()->getRGB()); self::assertEquals('0000FF', $style->getFill()->getStartColor()->getRGB()); self::assertEquals('0000FF', $style->getFill()->getEndColor()->getRGB()); $style = $firstSheet->getCell('B1')->getStyle(); self::assertEquals('000000', $style->getFont()->getColor()->getRGB()); self::assertEquals('000000', $style->getFill()->getEndColor()->getRGB()); self::assertEquals('FFFFFF', $style->getFill()->getstartColor()->getRGB()); $style = $firstSheet->getCell('C1')->getStyle(); self::assertEquals('f0f8ff', $style->getFont()->getColor()->getRGB()); self::assertEquals('eedfcc', $style->getFill()->getEndColor()->getRGB()); self::assertEquals('eedfcc', $style->getFill()->getstartColor()->getRGB()); $spreadsheet->disconnectWorksheets(); } public function testCanApplyInlineFontStyles(): void { $html = '
16px Times New Roman Bold Italic Underline Line through
'; $filename = HtmlHelper::createHtml($html); $spreadsheet = HtmlHelper::loadHtmlIntoSpreadsheet($filename, true); $firstSheet = $spreadsheet->getSheet(0); $style = $firstSheet->getCell('A1')->getStyle(); self::assertEquals(16, $style->getFont()->getSize()); $style = $firstSheet->getCell('B1')->getStyle(); self::assertEquals('Times New Roman', $style->getFont()->getName()); $style = $firstSheet->getCell('C1')->getStyle(); self::assertTrue($style->getFont()->getBold()); $style = $firstSheet->getCell('D1')->getStyle(); self::assertTrue($style->getFont()->getItalic()); $style = $firstSheet->getCell('E1')->getStyle(); self::assertEquals(Font::UNDERLINE_SINGLE, $style->getFont()->getUnderline()); $style = $firstSheet->getCell('F1')->getStyle(); self::assertTrue($style->getFont()->getStrikethrough()); $spreadsheet->disconnectWorksheets(); } public function testCanApplyInlineWidth(): void { $html = '
50px 100px 50px
'; $filename = HtmlHelper::createHtml($html); $spreadsheet = HtmlHelper::loadHtmlIntoSpreadsheet($filename, true); $firstSheet = $spreadsheet->getSheet(0); $dimension = $firstSheet->getColumnDimension('A'); self::assertNotNull($dimension); self::assertEquals(50, $dimension->getWidth()); $dimension = $firstSheet->getColumnDimension('B'); self::assertNotNull($dimension); self::assertEquals(100, $dimension->getWidth('px')); $dimension = $firstSheet->getColumnDimension('C'); self::assertNotNull($dimension); self::assertEquals(50, $dimension->getWidth('px')); $spreadsheet->disconnectWorksheets(); } public function testCanApplyInlineHeight(): void { $html = '
1
2
1
'; $filename = HtmlHelper::createHtml($html); $spreadsheet = HtmlHelper::loadHtmlIntoSpreadsheet($filename, true); $firstSheet = $spreadsheet->getSheet(0); $dimension = $firstSheet->getRowDimension(1); self::assertNotNull($dimension); self::assertEquals(50, $dimension->getRowHeight()); $dimension = $firstSheet->getRowDimension(2); self::assertNotNull($dimension); self::assertEquals(100, $dimension->getRowHeight('px')); $dimension = $firstSheet->getRowDimension(3); self::assertNotNull($dimension); self::assertEquals(50, $dimension->getRowHeight('px')); $spreadsheet->disconnectWorksheets(); } public function testCanApplyAlignment(): void { $html = '
Center align Center valign Center align Center valign Text indent Wraptext
'; $filename = HtmlHelper::createHtml($html); $spreadsheet = HtmlHelper::loadHtmlIntoSpreadsheet($filename, true); $firstSheet = $spreadsheet->getSheet(0); $style = $firstSheet->getCell('A1')->getStyle(); self::assertEquals(Alignment::HORIZONTAL_CENTER, $style->getAlignment()->getHorizontal()); $style = $firstSheet->getCell('B1')->getStyle(); self::assertEquals(Alignment::VERTICAL_CENTER, $style->getAlignment()->getVertical()); $style = $firstSheet->getCell('C1')->getStyle(); self::assertEquals(Alignment::HORIZONTAL_CENTER, $style->getAlignment()->getHorizontal()); $style = $firstSheet->getCell('D1')->getStyle(); self::assertEquals(Alignment::VERTICAL_CENTER, $style->getAlignment()->getVertical()); $style = $firstSheet->getCell('E1')->getStyle(); self::assertEquals(10, $style->getAlignment()->getIndent()); $style = $firstSheet->getCell('F1')->getStyle(); self::assertTrue($style->getAlignment()->getWrapText()); $spreadsheet->disconnectWorksheets(); } public function testCanApplyInlineDataFormat(): void { $html = '
2019-02-02 12:34:00 3 x
'; $filename = HtmlHelper::createHtml($html); $spreadsheet = HtmlHelper::loadHtmlIntoSpreadsheet($filename, true); $sheet = $spreadsheet->getSheet(0); self::assertEquals('mmm-yy', $sheet->getStyle('A1')->getNumberFormat()->getFormatCode()); self::assertEquals('2019-02-02 12:34:00', $sheet->getCell('A1')->getFormattedValue(), 'field is string not number so not formatted'); self::assertEquals('#.000', $sheet->getStyle('B1')->getNumberFormat()->getFormatCode()); self::assertEquals('3.000', $sheet->getCell('B1')->getFormattedValue(), 'format applied to numeric value'); self::assertEquals('#.000', $sheet->getStyle('C1')->getNumberFormat()->getFormatCode()); self::assertEquals('x', $sheet->getCell('C1')->getFormattedValue(), 'format not applied to non-numeric value'); $spreadsheet->disconnectWorksheets(); } public function testCanApplyCellWrapping(): void { $html = '
Hello World
Hello
World
Hello
World
'; $filename = HtmlHelper::createHtml($html); $spreadsheet = HtmlHelper::loadHtmlIntoSpreadsheet($filename, true); $firstSheet = $spreadsheet->getSheet(0); $cellStyle = $firstSheet->getStyle('A1'); self::assertFalse($cellStyle->getAlignment()->getWrapText()); $cellStyle = $firstSheet->getStyle('A2'); self::assertTrue($cellStyle->getAlignment()->getWrapText()); $cellValue = $firstSheet->getCell('A2')->getValue(); self::assertStringContainsString("\n", $cellValue); $cellStyle = $firstSheet->getStyle('A3'); self::assertTrue($cellStyle->getAlignment()->getWrapText()); $cellValue = $firstSheet->getCell('A3')->getValue(); self::assertStringContainsString("\n", $cellValue); $spreadsheet->disconnectWorksheets(); } public function testRowspanInRendering(): void { $filename = 'tests/data/Reader/HTML/rowspan.html'; $reader = new Html(); $spreadsheet = $reader->load($filename); $actual = $spreadsheet->getActiveSheet()->getMergeCells(); self::assertSame(['A2:C2' => 'A2:C2'], $actual); $spreadsheet->disconnectWorksheets(); } public function testTextIndentUseRowspan(): void { $html = '
1 Center Align Row
2 Text Indent
'; $filename = HtmlHelper::createHtml($html); $spreadsheet = HtmlHelper::loadHtmlIntoSpreadsheet($filename, true); $firstSheet = $spreadsheet->getSheet(0); $style = $firstSheet->getCell('C2')->getStyle(); self::assertEquals(10, $style->getAlignment()->getIndent()); $spreadsheet->disconnectWorksheets(); } public function testBorderWithRowspanAndColspan(): void { $html = '
NOT SPANNED SPANNED
NOT SPANNED
'; $reader = new Html(); $spreadsheet = $reader->loadFromString($html); $firstSheet = $spreadsheet->getSheet(0); $style = $firstSheet->getStyle('B1:C2'); $borders = $style->getBorders(); $totalBorders = [ $borders->getTop(), $borders->getLeft(), $borders->getBottom(), $borders->getRight(), ]; foreach ($totalBorders as $border) { self::assertEquals(Border::BORDER_THIN, $border->getBorderStyle()); } $spreadsheet->disconnectWorksheets(); } public function testBorderWithColspan(): void { $html = '
NOT SPANNED SPANNED
NOT SPANNED
'; $reader = new Html(); $spreadsheet = $reader->loadFromString($html); $firstSheet = $spreadsheet->getSheet(0); $style = $firstSheet->getStyle('B1:B2'); $borders = $style->getBorders(); $totalBorders = [ $borders->getTop(), $borders->getLeft(), $borders->getBottom(), $borders->getRight(), ]; foreach ($totalBorders as $border) { self::assertEquals(Border::BORDER_THIN, $border->getBorderStyle()); } $spreadsheet->disconnectWorksheets(); } public function testDataType(): void { $html = '
1 12345678987654 =B1 2022-02-21 10:20:30 null text with invalid datatype
'; $reader = new Html(); $spreadsheet = $reader->loadFromString($html); $firstSheet = $spreadsheet->getSheet(0); // check boolean data type self::assertEquals(DataType::TYPE_BOOL, $firstSheet->getCell('A1')->getDataType()); self::assertIsBool($firstSheet->getCell('A1')->getValue()); // check string data type self::assertEquals(DataType::TYPE_STRING, $firstSheet->getCell('B1')->getDataType()); self::assertIsString($firstSheet->getCell('B1')->getValue()); // check string with beginning equal sign (=B1) and string datatype,is not formula self::assertEquals(DataType::TYPE_STRING, $firstSheet->getCell('C1')->getDataType()); self::assertEquals('=B1', $firstSheet->getCell('C1')->getValue()); self::assertTrue($firstSheet->getCell('C1')->getStyle()->getQuotePrefix()); //check iso date self::assertEqualsWithDelta($firstSheet->getCell('D1')->getValue(), 44613.43090277778, 1.0e-12); //null self::assertEquals($firstSheet->getCell('E1')->getValue(), null); } }