phpexcel

PHPExcel

PHPExcel - OpenXML - Create Excel2007 documents in PHP - Spreadsheet engine Project providing a set of classes for the PHP programming language, which allow you to write to and read from different file formats, like Excel 2007, PDF, HTML, ... This project is built around Microsoft's OpenXML standard and PHP. Checkout the Features this class set provides, such as setting spreadsheet meta data (author, title, description, ...), multiple worksheets, different fonts and font styles, cell borders, fills, gradients, adding images to your spreadsheet and much, much more!

Want to bookmark this page? Please use http://www.phpexcel.net as the URL.

Resources ¶

Documentation ¶

Requirements ¶

Yii 1.0 or above

Installation ¶

Extract the release file under protected/extensions

Usage ¶

See the following code example:

$data = array(
    1 => array ('Name', 'Surname'),
    array('Schwarz', 'Oliver'),
    array('Test', 'Peter')
);
Yii::import('application.extensions.phpexcel.JPhpExcel');
$xls = new JPhpExcel('UTF-8', false, 'My Test Sheet');
$xls->addArray($data);
$xls->generateXML('my-test');

Change Log ¶

January 27, 2010 ¶

Initial release.

Total 9 comments

#4245

yusron at 2011/06/20 12:31am

only metadata

i have use this extension but fail... :( when I export only show metadata. like this :( http://www.yiiframework.com/forum/index.php?/topic/20626-ask-phpexcel-only-metadata/page__p__100974#entry100974

#2738

saebaryo at 2011/02/03 03:11pm

documentation

where i can get documentation for this extensions? or i just use documentation from codeplex? i want to merge some cell and give style, but i don't know how to do.

#2277

raa at 2010/12/06 06:32am

Thank you

it's much better then csv )

#432

undaverse at 2010/06/03 10:36am

Doesn't work

I've a problem.

I've tried to create a document like in the example. but it create me a excel sheet only with the menu and nothing else

is anybody know what does it mean ?

#433

undaverse at 2010/06/03 10:28am

2003 compatibility

Is there something about the compattibilities of the document for office 2003 ? I'm making some stuff for persons that use office 2003 and I need to garant that it will work on excel 2003.

there is something in phpexcel about compabitility but it's not present In that extension I see ....is anybody I've something about that ?

#496

j27lee at 2010/05/15 04:07am

new line?

Looks pretty promising. Any way to add a new line to a cell? I tried \n, but it just treated it as text.

Thanks!

#574

jerry2801 at 2010/04/20 06:01am

reply to neel

$this->layout=false;

it is you want to do?

#660

neel at 2010/03/26 01:22pm

Good Job

Excellent work. How to remove menu bar from xls page when save? I don't want to export menu bar.

#916

got 2 doodle at 2010/02/03 07:35pm

Any chance you can upload the file?

Hard to comment without a download, will you be uploading the file soon?

doodle

Please login to leave your comment.