Uncaught exception 'Exception' with message 'Column string index can not be longer than 2 characters.

Topics: Developer Forum
May 29, 2008 at 10:01 AM

problem is that there is no colomn that is longer than 2 characters

Fatal error:
Uncaught exception 'Exception' with message 'Column string index can not be longer than 2 characters.'
in /xls_test/1.6.1/Classes/PHPExcel/Cell.php:479

Stack trace: #0 /xls_test/1.6.1/Classes/PHPExcel/ReferenceHelper.php(450):
PHPExcel_Cell::columnIndexFromString('$AM') #1 /xls_test/1.6.1/Classes/PHPExcel/ReferenceHelper.php(397):
PHPExcel_ReferenceHelper->_updateSingleCellReference('$AM$3', 'A1', 0, 1) #2 /xls_test/1.6.1/Classes/PHPExcel/ReferenceHelper.php(311):
PHPExcel_ReferenceHelper->updateCellReference('$AM$3', 'A1', 0, 1) #3 /xls_test/1.6.1/Classes/PHPExcel/Reader/Excel2007.php(327):
PHPExcel_ReferenceHelper->updateFormulaReferences('=IF(S4=$AM$3,"O...', 'A1', 0, 1) #4 /xls_test/test.php(17):
PHPExcel_Reader_Excel2007->load('tr_seuranta.xls...') #5 {main} thrown in /xls_test/1.6.1/Classes/PHPExcel/Cell.php on line 479

Coordinator
May 29, 2008 at 12:36 PM
Can you try this using the latest source code? http://www.codeplex.com/PHPExcel/SourceControl/ListDownloadableCommits.aspx
May 30, 2008 at 8:07 AM


maartenba wrote:
Can you try this using the latest source code? http://www.codeplex.com/PHPExcel/SourceControl/ListDownloadableCommits.aspx



well .. error above might be fixed, but im getting error again..
Fatal error: Call to a member function children() on a non-object in /xls_test/PHPExcel/Reader/Excel2007.php on line 696