| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374 |
- <?php
- namespace PhpOffice\PhpSpreadsheetTests\Reader\Xml;
- use PhpOffice\PhpSpreadsheet\Cell\DataType;
- use PhpOffice\PhpSpreadsheet\Reader\Xml;
- use PHPUnit\Framework\TestCase;
- class XmlTest extends TestCase
- {
- /**
- * @dataProvider providerInvalidSimpleXML
- */
- public function testInvalidSimpleXML(string $filename): void
- {
- $this->expectException(\PhpOffice\PhpSpreadsheet\Reader\Exception::class);
- $xmlReader = new Xml();
- $xmlReader->trySimpleXMLLoadString($filename);
- }
- public function providerInvalidSimpleXML(): array
- {
- $tests = [];
- $glob = glob('tests/data/Reader/Xml/XEETestInvalidSimpleXML*.xml');
- self::assertNotFalse($glob);
- foreach ($glob as $file) {
- $tests[basename($file)] = [realpath($file)];
- }
- return $tests;
- }
- /**
- * Check if it can read XML Hyperlink correctly.
- */
- public function testHyperlinksAltCharset(): void
- {
- $reader = new Xml();
- $spreadsheet = $reader->load('tests/data/Reader/Xml/excel2003.iso8859-1.xml');
- $firstSheet = $spreadsheet->getSheet(0);
- self::assertSame('Voilà', $spreadsheet->getActiveSheet()->getCell('A1')->getValue());
- $hyperlink = $firstSheet->getCell('A2');
- self::assertEquals(DataType::TYPE_STRING, $hyperlink->getDataType());
- self::assertEquals('PhpSpreadsheet', $hyperlink->getValue());
- self::assertEquals('https://phpspreadsheet.readthedocs.io', $hyperlink->getHyperlink()->getUrl());
- }
- public function testLoadCorruptedFile(): void
- {
- $this->expectException(\PhpOffice\PhpSpreadsheet\Reader\Exception::class);
- $xmlReader = new Xml();
- $xmlReader->load('tests/data/Reader/Xml/CorruptedXmlFile.xml');
- }
- public function testListWorksheetNamesCorruptedFile(): void
- {
- $this->expectException(\PhpOffice\PhpSpreadsheet\Reader\Exception::class);
- $xmlReader = new Xml();
- $xmlReader->listWorksheetNames('tests/data/Reader/Xml/CorruptedXmlFile.xml');
- }
- public function testListWorksheetInfoCorruptedFile(): void
- {
- $this->expectException(\PhpOffice\PhpSpreadsheet\Reader\Exception::class);
- $xmlReader = new Xml();
- $xmlReader->listWorksheetInfo('tests/data/Reader/Xml/CorruptedXmlFile.xml');
- }
- }
|