"Sheet index is out of bounds." Exception

[dbonsch]

Especially if you have more than one sheet this error message does not really help to much.

Please add the requested $pIndex and the actual amount of sheets to the error message. That would help to find errors faster.

[Progi1984]

An example code ?

[dbonsch]

is thrown in
PHPExcel::removeSheetByIndex line: 261
PHPExcel::getSheet line: 283

$this->_workSheetCollection was empty ( still not shure how that could happen ) and i searched for a long time which sheet was missing, just to realize that $this->_workSheetCollection was empty.

I've commited a version with the extended messages in my fork.

[karak]

I had met this error too.
And I concluded it was bug the way to adjust active sheet index in removeSheetByIndex() then.
I hope my fix could also help you.

Present:
// this condition misses when active sheet is not at last
if (($this->_activeSheetIndex >= $pIndex) &&
($pIndex > count($this->_workSheetCollection) - 1)) {
--$this->_activeSheetIndex;
}

Fixed:
if (($this->_activeSheetIndex >= $pIndex) &&
($this->_activeSheetIndex > 0)) {
--$this->_activeSheetIndex;
}

[karak]

Sorry to have miss the point of your message.

[dbonsch]

You don't need to apologize. Thx for trying to help me. :-)

[JaceTan]

Hi I've got this error too.

However, commenting out lines 1717 to 1780 in PHPExcel/Reader/Excel2007.php (somewhat) solves this problem. We can now upload and process our sheets nicely.

Not sure if the removal of these lines will affect future codes.

Is there another fix? Possibly one that will be updated in the next version of PHPExcel?

We've also posted this in PHPExcel Codplex here: http://phpexcel.codeplex.com/discussions/249093

We're using version 1.7.8.

Thanks!

[huanggaoyuan2016]

Completely ignorant than

[iamMarkchu]

i use 1.7.4 version , the only way to solve 'Sheet index is out of bounds' this problem is to updated phpexcel?

[PowerKiKi]

1.7.4 was released on the 2010-08-26, almost 7 years ago. You should absolutely upgrade.