php-excel-reader

PHP Excel Reader - Parse and retrieve information from XLS files

This PHP library expands on the great work done in the PHP Excel Reader project on SourceForge.

It reads the binary format of XLS files directly and can return values and formats from any cell.

Resources ¶

Documentation ¶

Requirements ¶

Yii 1.0 or above

Installation ¶

Extract the release file under protected/extensions

Usage ¶

See the following code example:

Yii::import('ext.phpexcelreader.JPhpExcelReader');
$data=new JPhpExcelReader('example.xls');
echo $data->dump(true,true);

Change Log ¶

January 27, 2010 ¶

Initial release.

Total 4 comments

#5423

cass at 2011/10/10 09:35pm

Nice work

Works nicely for me. Made the changes as per the other comments as well. Thanks!

#5203

rashmani at 2011/09/22 03:45am

Very nice ext with a few glitches...

Hi there,

yep, very nice ext, I've got here while re-building our intranet. A couple of (small) glitches tough and some info:

'split' vs. 'explode' issue, as re1nald0 pointed out; I've substituted all occurrences and things seem to work fine
for testing purposes, I've added these two lines, which helped out tracking errors:

error_reporting(E_ALL ^ E_NOTICE);
ini_set('display_errors', 1);

to make things work, in function '_encodeUTF16' I had to change:

$result = mb_convert_encoding($string, $this->_defaultEncoding, 'UTF-16' );

into:

$result = mb_convert_encoding($string, $this->_defaultEncoding, 'UTF-8' );

still euro sign is not recognized, I've seen reports about this issue at google code but haven't found a solution yet. Nevertheless, very very useful one!

Ciao, rash*

#5163

jinmmd at 2011/09/20 01:10pm

You do the things I want to

Nowadays I used the PHPExcelReader in my website, I find it is very useful and efficacious, thank you for providing this extension, and I guess you can figure out the PHPExcelWirter in a few days. By the way, the PHPExcelReader is inherit from Spreadsheet_Excel_Writer.

#4897

re1nald0 at 2011/08/26 07:43am

Deprecated function in PHP 5.3

This is surely a useful extension; however, it uses 'split' function, which is deprecated if you use PHP 5.3. To solve it, we just need to change it to 'explode'.

Anyway, thank you for providing this extension :).

Please login to leave your comment.