Sanjeev Divekar

PhpExcel reader is good wrapper to read data from excel file. I have used this in one of my CakePHP project.

This is component class

class ExcelComponent
{
var $file = "";
var $setOutputEncoding = "UTF-8";
var $data;
var $controller;function startup( &$controller )
{
$this->controller = &$controller;
}function read()
{
vendor('Excel'.DS.'reader');
$this->data = new Spreadsheet_Excel_Reader();
$this->data->setOutputEncoding = $this->setOutputEncoding;
$this->data->read($this->file);
}
}

?>

• http://sourceforge.net/projects/phpexcelreader