expectException(ReaderException::class); $this->expectExceptionMessage('Invalid Spreadsheet file'); $xmlReader->load($filename); } public static function providerInvalidSimpleXML(): array { $tests = []; $glob = glob('tests/data/Reader/Xml/XEETestInvalidSimpleXML*.xml'); self::assertNotFalse($glob); foreach ($glob as $file) { $tests[basename($file)] = [(string) 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()); $spreadsheet->disconnectWorksheets(); } public function testLoadCorruptedFile(): void { $this->expectException(ReaderException::class); $this->expectExceptionMessage('Cannot load invalid XML file'); $xmlReader = new Xml(); $spreadsheet = @$xmlReader->load('tests/data/Reader/Xml/CorruptedXmlFile.xml'); } public function testListWorksheetNamesCorruptedFile(): void { $this->expectException(ReaderException::class); $this->expectExceptionMessage('Problem reading'); $xmlReader = new Xml(); $names = @$xmlReader->listWorksheetNames('tests/data/Reader/Xml/CorruptedXmlFile.xml'); self::assertNotEmpty($names); } public function testListWorksheetInfoCorruptedFile(): void { $this->expectException(ReaderException::class); $this->expectExceptionMessage('Problem reading'); $xmlReader = new Xml(); $info = @$xmlReader->listWorksheetInfo('tests/data/Reader/Xml/CorruptedXmlFile.xml'); self::assertNotEmpty($info); } public function testInvalidXMLFromString(): void { $xmlReader = new Xml(); $this->expectException(ReaderException::class); $this->expectExceptionMessage('Cannot load invalid XML string: 0'); $xmlReader->loadSpreadsheetFromString('0'); } public function testInvalidXMLFromEmptyString(): void { $xmlReader = new Xml(); $this->expectException(ReaderException::class); $this->expectExceptionMessage('Cannot load invalid XML string: '); $xmlReader->loadSpreadsheetFromString(''); } public function testEmptyFilename(): void { $xmlReader = new Xml(); $this->expectException(ReaderException::class); $this->expectExceptionMessage('File "" does not exist'); $xmlReader->load(''); } /** * Ensures that a PHP warning for `Undefined array key "x"` is not triggered. * * Relies on PHPUnit's conversion of PHP warnings, deprecations, and notices to exceptions. * If that warning occurs, the test should fail. */ public function testLoadXlsBug4669(): void { $filename = 'tests/data/Reader/Xml/bug4669.xml'; $reader = IOFactory::createReaderForFile($filename); $reader->setReadDataOnly(true); $spreadsheet = $reader->load($filename); $sheet = $spreadsheet->getActiveSheet(); self::assertSame('Report Date', $sheet->getCell('A1')->getValue()); $spreadsheet->disconnectWorksheets(); } }