can't open XLSX sheet, out of bounds -1

[gauze]

PHP Fatal error: Uncaught PhpOffice\PhpSpreadsheet\Exception: Your requested sheet index: -1 is out of bounds. The actual number of sheets is 0. in /home/gauze/phpspread/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Spreadsheet.php:626

$ file po1326.xlsx po1326.xlsx: Microsoft Excel 2007+

^ opens ok in windows and libreoffice

$ composer show|grep spreadsheet phpoffice/phpspreadsheet 4.1.0 PHPSpreadsheet - Read, Create and Write Spreadsheet documents in PHP - Spreadsheet engine

[code snippet] $inputFileType = 'Xlsx'; $inputFileName = DIR . '/po1326.xlsx';

$reader = IOFactory::createReader($inputFileType); $reader->setReadDataOnly(true);

$spreadsheet = $reader->load($inputFileName); $activeWorksheet = $spreadsheet->getActiveSheet(); [snip] throws error here.

I do not know what is wrong here.

thanks brian

[oleibman]

Neither do I. Can you upload your spreadsheet?

[gauze]

sure thing. I think I deleted anything "incriminating"

po1326.xlsx

[oleibman]

Thank you for providing your spreadsheet. I am unable to duplicate your result with that spreadsheet and your code. Is it possible that the error is happening later than you think? What release of PhpSpreadsheet (from the above I think it's 4.1.0) and Php are you using? What environment?

My code (only minor modifications from yours):

<?php

require __DIR__ . '/PhpSpreadsheet' . '/vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\IOFactory;

class issue4391 {
    public static function issue(): void
    {
        $inputFileType = 'Xlsx';
        $inputFileName = 'issue.4391.xlsx';
        $reader = IOFactory::createReader($inputFileType);
        $reader->setReadDataOnly(true);
        $spreadsheet = $reader->load($inputFileName);
        $activeWorksheet = $spreadsheet->getActiveSheet();
        var_dump($activeWorksheet->getCell('A7')->getValue());
    }
}

issue4391::issue();

My result:

C:\git\issue.4391.php:16:
string(3) "SEA"

[gauze]

I copied your code, changed the path to vendor/autoload.php same error :S

$ php testsheet.php PHP Fatal error: Uncaught PhpOffice\PhpSpreadsheet\Exception: Your requested sheet index: -1 is out of bounds. The actual number of sheets is 0. in /home/gauze/phpspread/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Spreadsheet.php:626 Stack trace: #0 /home/gauze/phpspread/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Spreadsheet.php(501): PhpOffice\PhpSpreadsheet\Spreadsheet->getSheet() #1 /home/gauze/phpspread/testsheet.php(14): PhpOffice\PhpSpreadsheet\Spreadsheet->getActiveSheet() #2 /home/gauze/phpspread/testsheet.php(19): issue4391::issue() #3 {main} thrown in /home/gauze/phpspread/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Spreadsheet.php on line 626

do my dependencies look ok? $ composer show composer/pcre 3.3.2 PCRE wrapping library that offers type-safe preg_* replacements. maennchen/zipstream-php 3.1.2 ZipStream is a library for dynamically streaming dynamic zip files from PHP without writing to the disk at all on... markbaker/complex 3.0.2 PHP Class for working with complex numbers markbaker/matrix 3.0.1 PHP Class for working with matrices phpoffice/phpspreadsheet 4.1.0 PHPSpreadsheet - Read, Create and Write Spreadsheet documents in PHP - Spreadsheet engine psr/http-client 1.0.3 Common interface for HTTP clients psr/http-factory 1.1.0 PSR-17: Common interfaces for PSR-7 HTTP message factories psr/http-message 2.0 Common interface for HTTP messages psr/simple-cache 3.0.0 Common interfaces for simple caching

[oleibman]

Your dependencies match mine. I am at a loss to think of why your result should differ from mine.

[gauze]

are there any environmental variables that could effect this? php?

[gauze]

I just tried this on an Ubuntu 24.04 machine (vs Fedora 41) and no errors. some kind of Fedora problem

[oleibman]

I'm glad you found this, but it seems awfully surprising. Do you have a way of testing if you can use ZipArchive on Fedora 41 to read other zip files? (An Xlsx spreadsheet is a zip archive composed mostly of xml files.)

[oleibman]

No update in 5 months. Closing.