mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-20 19:00:49 +00:00
Adrien Crivelli
ec4098c8fd
While we might never be able to have 100% of our code strict, we can at the very least do it for all of our tests. This ensures that our tests are using our API with the types as intended by the test author, and not silently be cast to what our API requires.
426 lines
17 KiB
PHP
426 lines
17 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Reader\Html;
|
|
|
|
use PhpOffice\PhpSpreadsheet\Cell\DataType;
|
|
use PhpOffice\PhpSpreadsheet\Reader\Exception as ReaderException;
|
|
use PhpOffice\PhpSpreadsheet\Reader\Html;
|
|
use PhpOffice\PhpSpreadsheet\Style\Alignment;
|
|
use PhpOffice\PhpSpreadsheet\Style\Border;
|
|
use PhpOffice\PhpSpreadsheet\Style\Font;
|
|
use PHPUnit\Framework\TestCase;
|
|
|
|
class HtmlTest extends TestCase
|
|
{
|
|
public function testCsvWithAngleBracket(): void
|
|
{
|
|
$filename = 'tests/data/Reader/HTML/csv_with_angle_bracket.csv';
|
|
$reader = new Html();
|
|
self::assertFalse($reader->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, ' <html> ' . $padding . ' </html> '],
|
|
[true, ' <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html>' . $padding . '</html>'],
|
|
[true, '<html></html>'],
|
|
[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 = '<table>
|
|
<tr>
|
|
<td style="background-color: #0000FF;color: #FFFFFF">Blue background</td>
|
|
<td style="background-color: unknown1;color: unknown2">Unknown fore/background</td>
|
|
<td style="background-color: antiquewhite2;color: aliceblue">Unknown fore/background</td>
|
|
</tr>
|
|
</table>';
|
|
$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 = '<table>
|
|
<tr>
|
|
<td style="font-size: 16px;">16px</td>
|
|
<td style="font-family: \'Times New Roman\'">Times New Roman</td>
|
|
<td style="font-weight: bold;">Bold</td>
|
|
<td style="font-style: italic;">Italic</td>
|
|
<td style="text-decoration: underline;">Underline</td>
|
|
<td style="text-decoration: line-through;">Line through</td>
|
|
</tr>
|
|
</table>';
|
|
$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 = '<table>
|
|
<tr>
|
|
<td width="50">50px</td>
|
|
<td style="width: 100px;">100px</td>
|
|
<td width="50px">50px</td>
|
|
</tr>
|
|
</table>';
|
|
$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 = '<table>
|
|
<tr>
|
|
<td height="50">1</td>
|
|
</tr>
|
|
<tr>
|
|
<td style="height: 100px;">2</td>
|
|
</tr>
|
|
<tr>
|
|
<td height="50px">1</td>
|
|
</tr>
|
|
</table>';
|
|
$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 = '<table>
|
|
<tr>
|
|
<td align="center">Center align</td>
|
|
<td valign="center">Center valign</td>
|
|
<td style="text-align: center;">Center align</td>
|
|
<td style="vertical-align: center;">Center valign</td>
|
|
<td style="text-indent: 10px;">Text indent</td>
|
|
<td style="word-wrap: break-word;">Wraptext</td>
|
|
</tr>
|
|
</table>';
|
|
$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 = '<table>
|
|
<tr>
|
|
<td data-format="mmm-yy">2019-02-02 12:34:00</td>
|
|
<td data-format="#.000">3</td>
|
|
<td data-format="#.000">x</td>
|
|
</tr>
|
|
</table>';
|
|
$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 = '<table>
|
|
<tr>
|
|
<td>Hello World</td>
|
|
</tr>
|
|
<tr>
|
|
<td>Hello<br />World</td>
|
|
</tr>
|
|
<tr>
|
|
<td>Hello<br>World</td>
|
|
</tr>
|
|
</table>';
|
|
$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 = '<table>
|
|
<tr>
|
|
<td>1</td>
|
|
<td rowspan="2" style="vertical-align: center;">Center Align</td>
|
|
<td>Row</td>
|
|
</tr>
|
|
<tr>
|
|
<td>2</td>
|
|
<td style="text-indent:10px">Text Indent</td>
|
|
</tr>
|
|
</table>';
|
|
$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 = '<table>
|
|
<tr>
|
|
<td style="border: 1px solid black;">NOT SPANNED</td>
|
|
<td rowspan="2" colspan="2" style="border: 1px solid black;">SPANNED</td>
|
|
</tr>
|
|
<tr>
|
|
<td style="border: 1px solid black;">NOT SPANNED</td>
|
|
</tr>
|
|
</table>';
|
|
|
|
$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 = '<table>
|
|
<tr>
|
|
<td style="border: 1px solid black;">NOT SPANNED</td>
|
|
<td colspan="2" style="border: 1px solid black;">SPANNED</td>
|
|
</tr>
|
|
<tr>
|
|
<td style="border: 1px solid black;">NOT SPANNED</td>
|
|
</tr>
|
|
</table>';
|
|
|
|
$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 = '<table>
|
|
<tr>
|
|
<td data-type="b">1</td>
|
|
<td data-type="s">12345678987654</td>
|
|
<!-- in some cases, you may want to treat the string with beginning equal sign as a string rather than a formula -->
|
|
<td data-type="s">=B1</td>
|
|
<td data-type="d">2022-02-21 10:20:30</td>
|
|
<td data-type="null">null</td>
|
|
<td data-type="invalid-datatype">text with invalid datatype</td>
|
|
</tr>
|
|
</table>';
|
|
|
|
$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);
|
|
}
|
|
}
|