Issue2516Test.php 1.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162
  1. <?php
  2. namespace PhpOffice\PhpSpreadsheetTests\Reader\Xlsx;
  3. use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
  4. use PHPUnit\Framework\TestCase;
  5. class Issue2516Test extends TestCase
  6. {
  7. /**
  8. * @var string
  9. */
  10. private static $testbook = 'tests/data/Reader/XLSX/issue.2516b.xlsx';
  11. public function testPreliminaries(): void
  12. {
  13. $file = 'zip://';
  14. $file .= self::$testbook;
  15. $file .= '#docProps/thumbnail.wmf';
  16. $data = file_get_contents($file);
  17. // confirm that file exists
  18. self::assertNotFalse($data, 'thumbnail.wmf not exists');
  19. $file = 'zip://';
  20. $file .= self::$testbook;
  21. $file .= '#_rels/.rels';
  22. $data = file_get_contents($file);
  23. // confirm that file contains expected namespaced xml tag
  24. if ($data === false) {
  25. self::fail('Unable to read file .rels');
  26. } else {
  27. self::assertStringContainsString('Type="http://schemas.openxmlformats.org/package/2006/relationships/metadata/thumbnail" Target="docProps/thumbnail.wmf"', $data);
  28. }
  29. }
  30. public function testIssue2516a(): void
  31. {
  32. $filename = self::$testbook;
  33. $reader = new Xlsx();
  34. $names = $reader->listWorksheetNames($filename);
  35. $expected = ['Sheet1'];
  36. self::assertSame($expected, $names);
  37. }
  38. public function testIssue2516b(): void
  39. {
  40. $filename = self::$testbook;
  41. $reader = new Xlsx();
  42. $infos = $reader->listWorksheetInfo($filename);
  43. $expected = [
  44. [
  45. 'worksheetName' => 'Sheet1',
  46. 'lastColumnLetter' => 'B',
  47. 'lastColumnIndex' => 1,
  48. 'totalRows' => '6',
  49. 'totalColumns' => 2,
  50. ],
  51. ];
  52. self::assertSame($expected, $infos);
  53. }
  54. }