Error: 'Invalid cell coordinate A100000'

Topics: User Forum
Jan 10, 2011 at 2:11 PM
Edited Jan 10, 2011 at 2:12 PM

I'm trying to parse a file and getting this error:
Fatal error: Uncaught exception 'Exception' with message 'Invalid cell coordinate A100000'
  in E:\wamp\www\listinventory\PHPExcel\Classes\PHPExcel\Cell.php:501
Stack trace: #0 E:\wamp\www\listinventory\PHPExcel\Classes\PHPExcel\Reader\Excel2007.php(696):

file is located here:

Sheet has 172227 rows, 4 columns

Using PHPExcel v1.7.5

Any ideas?

Jan 10, 2011 at 3:22 PM

Work Item 15029 fixed in latest SVN code.

Jan 10, 2011 at 4:07 PM

When will it be avail in a release? I do not install code from a repository.

Jan 10, 2011 at 4:28 PM

Target date for the 1.7.6 release is late January/early February.

In addition to the bugfixes and changes already included in SVN, main priorities are to finally incorporate the charting (for Excel2007, that I've been working on for much of the last year); OOCalc, Gnumeric and Excel2003XML Writers; and a basic HTML reader; as well as extending the supported statistical and financial functions; an improved OLE Writer for Excel5 that will support Workbook properties); and Cell Notes in Excel5. Optional use of PCLZip for those who encounter problems with PHP's ZipArchive is already included in the appropriate Writers, and I want to try and get this included in the relevant Readers as well.


Target date for the 1.7.7 release is around April/May.

I'm planning to look at the Excel Database functions; a first pass at implementing Pivot tables; and extending Chart support to other readers/writers.