Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fatal error: Uncaught exception 'PHPExcel_Exception' with message 'Invalid cell coordinate' related to Workbook name #198

Closed
BlackPage05 opened this issue Aug 10, 2017 · 1 comment

Comments

@BlackPage05
Copy link

Hi there,
I'm encountering a problem I cannot seem to be able to resolve upon trying to save a xlsx file based on the attached xlsx source

Here is the stack trace of the error

Fatal error: Uncaught exception 'PHPExcel_Exception' with message 'Invalid cell coordinate 'EAF-CLAN'' in /var/www/html/inc/lib/phpexcel/classes/PHPExcel/Cell.php:590
Stack trace:
#0 /var/www/html/inc/lib/phpexcel/classes/PHPExcel/Cell.php(643): PHPExcel_Cell::coordinateFromString(''EAF-CLAN'')
#1 /var/www/html/inc/lib/phpexcel/classes/PHPExcel/Cell.php(618): PHPExcel_Cell::absoluteCoordinate(''EAF-CLAN'')
#2 /var/www/html/inc/lib/phpexcel/classes/PHPExcel/Writer/Excel2007/Workbook.php(331): PHPExcel_Cell::absoluteReference(''EAF-CLAN'')
#3 /var/www/html/inc/lib/phpexcel/classes/PHPExcel/Writer/Excel2007/Workbook.php(308): PHPExcel_Writer_Excel2007_Workbook->_writeDefinedNameForNamedRange(Object(PHPExcel_Shared_XMLWriter), Object(PHPExcel_NamedRange))
#4 /var/www/html/inc/lib/phpexcel/classes/PHPExcel/Writer/Excel2007/Workbook.php(277): PHPExcel_Writer_Excel2007_Workbook->_writeNamedRanges(Object(PHPExcel_Shared_XMLWriter), Object(PHPExcel))
#5 /var/www/html/inc/lib/phpexcel/classes/PHPExcel/Writer/Excel2007/Workbook.php( in /var/www/html/inc/lib/phpexcel/classes/PHPExcel/Cell.php on line 590

And here is the xlsx source file

bc_sfr_fibre.xlsx

What the required php code does is :

Open the source file
Update values in certain cells
Save the result as a new xlsx file

The problem il located when trying to save the result file :

$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); print "go"; $objWriter->save($C->path() . $Final_File); print "done";
Go is displayed, done is never reached

I've been trying to find the error for weeks but can't seem to grasp it...

Thx in advance

@PowerKiKi
Copy link
Member

Unfortunately this is the wrong project, you are using PHPExcel, not PhpSpreadsheet. Try to reproduce your issue without the need of your source xlsx file and re-submit over there: https://github.com/PHPOffice/PHPExcel

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

2 participants