mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-23 15:52:12 +00:00
oleibman
84cc3b560f
Its latest update added some new stringencies, resulting in 62 messages. Used `composer fix` to take care of them.
126 lines
4.3 KiB
PHP
126 lines
4.3 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Reader\Html;
|
|
|
|
use PhpOffice\PhpSpreadsheet\Reader\Exception as ReaderException;
|
|
use PhpOffice\PhpSpreadsheet\Reader\Html;
|
|
use PHPUnit\Framework\TestCase;
|
|
|
|
class HtmlLoadStringTest extends TestCase
|
|
{
|
|
public function testCanLoadFromString(): void
|
|
{
|
|
$html = '<table>
|
|
<tr>
|
|
<td>Hello World</td>
|
|
</tr>
|
|
<tr>
|
|
<td>Hello<br />World</td>
|
|
</tr>
|
|
<tr>
|
|
<td>Hello<br>World</td>
|
|
</tr>
|
|
</table>';
|
|
$spreadsheet = (new Html())->loadFromString($html);
|
|
$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);
|
|
}
|
|
|
|
public function testLoadInvalidString(): void
|
|
{
|
|
if (method_exists($this, 'setOutputCallback')) {
|
|
$this->expectException(ReaderException::class);
|
|
$html = '<table<>';
|
|
(new Html())->loadFromString($html);
|
|
} else {
|
|
// The meat of this test runs in HtmlPhpunit10Test
|
|
self::assertTrue(true);
|
|
}
|
|
}
|
|
|
|
public function testCanLoadFromStringIntoExistingSpreadsheet(): void
|
|
{
|
|
$html = '<table>
|
|
<tr>
|
|
<td>Hello World</td>
|
|
</tr>
|
|
<tr>
|
|
<td>Hello<br />World</td>
|
|
</tr>
|
|
<tr>
|
|
<td>Hello<br>World</td>
|
|
</tr>
|
|
</table>';
|
|
$reader = new Html();
|
|
$spreadsheet = $reader->loadFromString($html);
|
|
$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);
|
|
|
|
$reader->setSheetIndex(1);
|
|
$html = '<table>
|
|
<tr>
|
|
<td>Goodbye World</td>
|
|
</tr>
|
|
</table>';
|
|
|
|
self::assertEquals(1, $spreadsheet->getSheetCount());
|
|
$spreadsheet = $reader->loadFromString($html, $spreadsheet);
|
|
self::assertEquals(2, $spreadsheet->getSheetCount());
|
|
}
|
|
|
|
public function testCanLoadDuplicateTitle(): void
|
|
{
|
|
$html = <<<'EOF'
|
|
<html>
|
|
<head>
|
|
<title>Sheet</title>
|
|
</head>
|
|
<body>
|
|
<table><tr><td>1</td></tr></table>
|
|
</body>
|
|
</html>
|
|
EOF;
|
|
$reader = new Html();
|
|
$spreadsheet = $reader->loadFromString($html);
|
|
$reader->setSheetIndex(1);
|
|
$reader->loadFromString($html, $spreadsheet);
|
|
$reader->setSheetIndex(2);
|
|
$reader->loadFromString($html, $spreadsheet);
|
|
$sheet = $spreadsheet->getSheet(0);
|
|
self::assertEquals(1, $sheet->getCell('A1')->getValue());
|
|
self::assertEquals('Sheet', $sheet->getTitle());
|
|
$sheet = $spreadsheet->getSheet(1);
|
|
self::assertEquals(1, $sheet->getCell('A1')->getValue());
|
|
self::assertEquals('Sheet 1', $sheet->getTitle());
|
|
$sheet = $spreadsheet->getSheet(2);
|
|
self::assertEquals(1, $sheet->getCell('A1')->getValue());
|
|
self::assertEquals('Sheet 2', $sheet->getTitle());
|
|
}
|
|
}
|