ASK PHPExcel only metadata

hai guys i want to ask.

I want to create report to excel use phpexcel

i try from bega and

but just only show meta data.

public function actionExcel()


                $model=new Kelurahan('search');




                        $dataProvider= $model->search();

                        $dataProvider->pagination= false; // for retrive all modules

            $data = $dataProvider->data;

            foreach ($data as $model)


                $test = array($model);



                        $xls = new JPhpExcel('UTF-8', false, 'test');









in page view admin.php


<?php $this->widget('zii.widgets.grid.CGridView', array(






                    'header' => 'No',









)); ?>

SS like this

::) ::)

when my application also do in the same but i cant get it,please help me,i cant get any errors,bt how will see the output

my problem is the same…

it’s funny, a few minute earlier i can download the excell fine.

have you find the solution guys??

Need ut help please bout Excell from YII

Hi tieulonglanh.

I have read you post about a new way to use PHPExcell.

but i have this problem, after i do as you wrote in the manual. when i tried to run the web,

there is an error as below :

Alias "application.extensions.PHPExcel" is invalid. Make sure it points to an existing PHP file.

it’s like that yii wont recognize my setting in the config/main.php :



		// enable cookie-based authentication







in the controller i have wrote it down like this:

//Save to abc.xlsx file

    // You can use like PHPExcel documentation from codeplex: 

    //&#036;objWriter = new PHPExcel_Writer_Excel2007(&#036;objPHPExcel);



can you please correct me if there something missing?

or the file that I have downloaded to be put in the application/extensions is not completed?

thank you for your kind response.