Problems with Cell Iteration

Topics: Developer Forum, User Forum
Jan 3, 2011 at 12:47 PM

Hi all,

Happy New Year!

I am using PHP 5.3.2 on Ubuntu 10.04 64-bit and an SVN download of PHP Excel from 26th of December 2010.

I have the following problems with extracting data from xls(x) files:

1. When using setIterateOnlyExistingCells(true), in some sheets, cells get shifted quite randomly (some rows are fine, and then some rows are shifted) so that they are no longer in the same column as they appear in the spreadsheet when opened in Excel.

2. When using setIterateOnlyExistingCells(false), in some sheets, I end up with 16,000+ columns and who knows how many rows of mostly empty cells (from a sheet which contains around ~10 columns and ~100 rows), which results in "out of memory" situation eventually (exceeds 2.5GB).

Is there anything that I can do about this so I can use either the one or the other iteration mode, but yet ensure that all the columns/rows are aligned exactly the same as when viewed in Excel, and only get cells up to the max column/row that contain an actual value.

I am willing to provide sample files resulting in these problems to aid further investigation.

Thank you!