Call to undefined method PHPExcel::setCellValueByColumnAndRow()

Oct 21, 2010 at 2:42 PM


For some reason I can't use the method "setCellValueByColumnAndRow()", I can only use "setCellValue". As far as I understand, the directory structure is intact. Do I need to include any file besides PHPExcel.php in order to use this functionality?

I have PHP 5.2.8 and I use PHPExcel 1.7.4.

Thanks in advance!

Oct 21, 2010 at 2:46 PM

Never mind, I did sove the problem my self.

Oct 22, 2010 at 8:25 AM

glad you were able to solve this yourself.

Jan 19, 2011 at 4:56 AM


So what is the solution to use setCellValueByColumnAndRow()?

I have the same problem on php v5.3.0 and PHPExcel v1.7.5

Fatal error: Call to undefined method PHPExcel::setCellValueByColumnAndRow()

Thanks for your help.


Jan 19, 2011 at 8:02 AM
Edited Jan 19, 2011 at 8:03 AM

Your problem is possibly the fact that setCellValueByColumnAndRow() is not a method of the PHPExcel object, but of the PHPExcel_Worksheet object

A workbook (PHPExcel object) doesn't have cells, it has one or more worksheets (PHPExcel_Worksheet objects); and it's the worksheets that have cells