How to read Excel documents?

Topics: Project Management Forum, User Forum
Feb 2, 2015 at 11:05 AM
Edited Feb 2, 2015 at 11:06 AM
Hi There,

I'm currently trying to use your library to read an Excel document, but am encountering issues (created by myself, i might add, this is not a bug report). I have referenced the what i have gathered are the correct files for this purpose (IOFactory.php) and have tried to use the following:

require_once 'C:\xampp\htdocs\Web App\PHPExcel\classes\phpexcel\IOFactory.php';
$objPHPExcel = PHPExcel_IOFactory::load("example report.xlsx");
echo "$objPHPExcel->getActiveSheet()->getCell('K12')";

[ i'm aware my echo'ing is wrong, i'll fix that after this issue :) ]

However i cant seem to get this to work, i get the following message:

Notice: Undefined property: PHPExcel::$getActiveSheet in C:\xampp\htdocs\Web App\Fospha Score Gen.php on line 33
()->getCell('K12')


Some help and pointers would be appreciated on where im going wrong/ what i should be doing. I got most of what i have done here from reading ' http://blog.mayflower.de/561-Import-and-export-data-using-PHPExcel.html '

I've used this as i'm a newb to coding etc, but have decided to dive right in, so this would be a helpful learning experience too.

Many Thanks,

Stephen