Login   Register  
PHP Classes
elePHPant
Icontem

Failing to read empty sheets in PHP 5.4.12

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

      Simple XLSX  >  All threads  >  Failing to read empty sheets in PHP 5.4.12  >  (Un) Subscribe thread alerts  
Subject:Failing to read empty sheets in PHP 5.4.12
Summary:oh dog
Messages:4
Author:real name
Date:2013-02-23 14:43:18
Update:2013-02-24 12:41:43
 

  1. Failing to read empty sheets in PHP 5.4.12   Reply  
Picture of real name
real name
2013-02-23 14:43:18
0.6.2 failed to read empty worksheets and the following patch fixed it for me.

107c107
< $index = $this->_columnIndex( end($d) );
---
> $index = $this->_columnIndex( $d[1] );


Please consider hosting this project in github.
Thanks.

  2. Re: Failing to read empty sheets in PHP 5.4.12   Reply  
Picture of Sergey Shuchkin
Sergey Shuchkin
2013-02-24 08:32:10 - In reply to message 1 from real name
I tried trigger this error, but don't have yours results.

I did empty.xlsx

$xlsx = new SimpleXLSX('empty.xlsx');

print_r( $xlsx->dimension(1) );

---
Array
(
[0] => 0
[1] => 0
)

  3. Re: Failing to read empty sheets in PHP 5.4.12   Reply  
Picture of real name
real name
2013-02-24 12:31:59 - In reply to message 2 from Sergey Shuchkin
My file is a premade one with one large sheet and two empty ones. I'm sorry but I'm not allowed to share it.
In my case it seems that only the width dimension is being set to empty sheets, thus $ws->dimension['ref'] is only 'A1'.

  4. Re: Failing to read empty sheets in PHP 5.4.12   Reply  
Picture of real name
real name
2013-02-24 12:41:43 - In reply to message 3 from real name
And the error I'm getting is Undefined offset: 1 for $d[1] in line 107. This might have been just a warning in previous PHP versions.