While searching for an elegant solution of reading excel files with CodeIgniter I found this one here—> http://code.google.com/p/php-excel-reader/
There have been some severity depreciated php errors in the code.
I’ve fixed them and adjusted the constructor to enable it, reading a params array passed by CodeIgniter’s loader.
You can download it here:
File:Spreadsheet Excel Reader.zip
1. Save the Spreadsheet_Excel_Reader.php from downloaded archive to
./system/application/libraries/
2. change error_reporting in your index.php to
error_reporting(E_ALL ^ E_NOTICE);
3. Add this to you Controller
$pathToFile = ‘anyPath’;
$params = array(‘file’ => $pathToFile, ‘store_extended_info’ => true,‘outputEncoding’ => ‘’);
$this->load->library(‘Spreadsheet_Excel_Reader’, $params);
$data[‘xlsFile’] = $this->spreadsheet_excel_reader->dump(true, true);
$this->load->view(‘yourView’, $data);
4. and this to your View
<?php echo $xlsFile; ?>