phpexcel

Yii Framework Extensions

Popular Tags

phpexcel PHPExcel

Documentation
Change Log

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.

21 10

31 followers

13 049 downloads

Yii Version: 1.1

License: BSD-2-Clause

Category: File System

Tags:

Developed by: jerry2801

Created on: Jan 27, 2010

Last updated: 14 years ago

Downloads

show all

User Contributed Notes 18

#432

0 0

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 ?

undaverse at Jun 3, 2010, 2:36:16 PM

#433

0 0

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 ?

undaverse at Jun 3, 2010, 2:28:40 PM

#496

0 0

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!

James at May 15, 2010, 8:07:16 AM

#574

0 0

reply to neel

$this->layout=false;

it is you want to do?

jerry2801 at Apr 20, 2010, 10:01:21 AM

#660

0 0

Good Job

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

neel at Mar 26, 2010, 5:22:02 PM

#916

0 0

Any chance you can upload the file?

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

doodle

got 2 doodle at Feb 4, 2010, 12:35:47 AM

#2277

0 0

Thank you

it's much better then csv )

Sasha at Dec 6, 2010, 11:32:37 AM

#2738

0 0

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.

saebaryo at Feb 3, 2011, 8:11:44 PM

#4245

1 0

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

yusron at Jun 20, 2011, 4:31:30 AM

#7071

1 0

PHPExcel is used here??

I took a look at the code (just a few lines of code in 2 PHP file) and was unable to find any reference to the Codeplex phpexcel library. It this library used here?
As far as I see is impossible to use the advanced functions of Codeplex, this class only allows to create cells and insert simple values creating XML at hand. I'm right?

jpablo at Feb 22, 2012, 2:12:16 PM

#8482

0 0

font style

how is used font style?

For example this

bachem at Jun 6, 2012, 9:53:49 PM

#9697

0 0

Nice extension

Nice extension, very easy to setup...3 minutes. However, i dont own excel and to verify that the spreadsheet is valid i tried to upload to Google docs. However Google doesnt recognize the format. I think ive tried all type of excel documents without any problems in the past so probably the format is broken. Anyone know anything that could help? Will read some docs how to create excel sheets from scratch now. Thank you very much.

nights at Sep 4, 2012, 10:01:11 AM

#10304

0 0

@nights

Try Open Office free software that will save a file in excel format...

deez at Oct 18, 2012, 1:27:38 PM

#10558

1 0

why demo link is not working?

the "try out demo" link is not working can you fix it?

whaleforever at Nov 5, 2012, 3:07:10 AM

#11435

0 0

This need some changes

The way you use $data in export is not gonna fly. In real wold when you need to pull 10K rows from data using Yii active record, what you get is an array of OBJECTS, not array of array. Consider performance and resource, you cannot convert that array to another array to export.

Hudson Nguyen at Jan 14, 2013, 9:57:19 AM

#11751

0 0

how to save generated file

i have used this extension and its work fine.
but when i save the file on my computer prior to open it, it works, but when i just download/open it, it frozes!

like if i s when i select open with(Microsft)...then file name is changed to test.xls.xlsx how can i fix that ?

chaitsi at Feb 1, 2013, 11:26:13 AM

#13671

0 0

Hi Its not working my dynamic array couold any body solved it

I am trying to export my custom array to the excel sheet but its not working. My custom array is dynamic array wihc has the following format. Note that the it has no comma seperated array value so its not working for me. So i am searching for solution.

$data = array(
    1 => array ('Name', 'Surname')
    array('Schwarz', 'Oliver')
    array('Test', 'Peter')
);

nirmalroka at Jun 15, 2013, 4:30:00 PM

#14464

0 0

Turkish character problem.

Hi!

I have an error with my array data as follows.

$data = array(
		    1 => array ('İSİM', 'SOYİSİM'),
		    array('İŞÇÖ', 'ÇŞÖŞÜĞ')
		);

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

Above characters are turkish . How can i fix the problem ?

drxy at Aug 13, 2013, 6:09:18 PM

Categories