XmlTest.php 2.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374
  1. <?php
  2. namespace PhpOffice\PhpSpreadsheetTests\Reader\Xml;
  3. use PhpOffice\PhpSpreadsheet\Cell\DataType;
  4. use PhpOffice\PhpSpreadsheet\Reader\Xml;
  5. use PHPUnit\Framework\TestCase;
  6. class XmlTest extends TestCase
  7. {
  8. /**
  9. * @dataProvider providerInvalidSimpleXML
  10. */
  11. public function testInvalidSimpleXML(string $filename): void
  12. {
  13. $this->expectException(\PhpOffice\PhpSpreadsheet\Reader\Exception::class);
  14. $xmlReader = new Xml();
  15. $xmlReader->trySimpleXMLLoadString($filename);
  16. }
  17. public function providerInvalidSimpleXML(): array
  18. {
  19. $tests = [];
  20. $glob = glob('tests/data/Reader/Xml/XEETestInvalidSimpleXML*.xml');
  21. self::assertNotFalse($glob);
  22. foreach ($glob as $file) {
  23. $tests[basename($file)] = [realpath($file)];
  24. }
  25. return $tests;
  26. }
  27. /**
  28. * Check if it can read XML Hyperlink correctly.
  29. */
  30. public function testHyperlinksAltCharset(): void
  31. {
  32. $reader = new Xml();
  33. $spreadsheet = $reader->load('tests/data/Reader/Xml/excel2003.iso8859-1.xml');
  34. $firstSheet = $spreadsheet->getSheet(0);
  35. self::assertSame('Voilà', $spreadsheet->getActiveSheet()->getCell('A1')->getValue());
  36. $hyperlink = $firstSheet->getCell('A2');
  37. self::assertEquals(DataType::TYPE_STRING, $hyperlink->getDataType());
  38. self::assertEquals('PhpSpreadsheet', $hyperlink->getValue());
  39. self::assertEquals('https://phpspreadsheet.readthedocs.io', $hyperlink->getHyperlink()->getUrl());
  40. }
  41. public function testLoadCorruptedFile(): void
  42. {
  43. $this->expectException(\PhpOffice\PhpSpreadsheet\Reader\Exception::class);
  44. $xmlReader = new Xml();
  45. $xmlReader->load('tests/data/Reader/Xml/CorruptedXmlFile.xml');
  46. }
  47. public function testListWorksheetNamesCorruptedFile(): void
  48. {
  49. $this->expectException(\PhpOffice\PhpSpreadsheet\Reader\Exception::class);
  50. $xmlReader = new Xml();
  51. $xmlReader->listWorksheetNames('tests/data/Reader/Xml/CorruptedXmlFile.xml');
  52. }
  53. public function testListWorksheetInfoCorruptedFile(): void
  54. {
  55. $this->expectException(\PhpOffice\PhpSpreadsheet\Reader\Exception::class);
  56. $xmlReader = new Xml();
  57. $xmlReader->listWorksheetInfo('tests/data/Reader/Xml/CorruptedXmlFile.xml');
  58. }
  59. }