Export Cgridview (With Custom Columns) To Excel

Yii 1.1 General Discussion
1

Hi All,

I have a CGridView which uses Active Records as well as some functions defined in the model so as to make it custom. This works perfectly fine for Cgridview. But I do want to export the same data to the excel sheet.

I have tried using ExcelView but it doesnot seem to support the below code.

$data->getCallActions() doesn’'t seem to work





EExcelView Code:


$this->widget('ext.eexcelview.EExcelView', array(

		'dataProvider'=> $dataProvider,

		'title'=>'Title',

		'autoWidth'=>false,

		'disablePaging'=>true,		

		'columns' => array(

					'id',

					'caller_number',

					array(

						'name'=>'Action',

						'type'=>'raw',

						'value'=>'$data->getCallActions()',

					),

					'created_date',

				)		

			)

		);

Also I tried using other Excel Imports but doesnot seem to be working.

Please do let me know.

Thank you.

2

Hi,

May be you sould call the same function from controller…lets try to keep access controller details