[Solved] Phpexcel - Error On Using Getvalue()


I’m using PHPExcel to import a list of data from MS Excel (97-2003) into MySQL. I wrote the code as follows:

$objExcel = new PHPExcel();

$fileType = 'Excel5';

$objReader = PHPExcel_IOFactory::createReader($fileType);



$objPHPExcel = $objReader->load('list.xls');

$worksheet = $objPHPExcel->getActiveSheet();

$modelPrize->price = $worksheet->getCellByColumnAndRow(5, $row)->getValue();

The code was fine when I built in development environment (using MS Windows). But, it was going to error when I deployed into testing environment (using Linux) with following error:

PHP Fatal error: Can’t use function return value in write context in /home/<the_page> on line <where_I_wrote_$modelPrize->price = $worksheet->getCellByColumnAndRow(5, $row)->getValue();>

PHP Fatal error: Class declarations may not be nested in /home/lottery/php_framework/Yii-1.1.14/framework/collections/CListIterator.php on line 20

Is there something missing in my code? Is there something I need to check with the server configuration?



This problem is solved by moving the application to the new server. The moving is not because of this problem but it’s already scheduled by server administrator. So, I have no idea what the root caused of this problem is. Solved involuntary.