Hi, sorry for my english.
I use extension tblexcelview. Thas is link: tblexcelview
I add some code for filter.
This’s my code:
<?php $this->widget('application.components.widgets.tlbExcelView', array(
'id' => 'some-grid',
'dataProvider' => $model->search(),
'filter'=>$model,
'enablePagination' => true,
'template' => "{pager}\n{summary}\n{items}\n{pager}",
'grid_mode' => $production, // Same usage as EExcelView v0.33
//'template' => "{summary}\n{items}\n{exportbuttons}\n{pager}",
'title' => 'test' . date('d-m-Y - H-i-s'),
'creator' => 'My name',
'subject' => mb_convert_encoding('Something important with a date in French: ' . utf8_encode(strftime('%e %B %Y')), 'ISO-8859-1', 'UTF-8'),
'description' => mb_convert_encoding('Etat de production généré à la demande par l\'administrateur (some text in French).', 'ISO-8859-1', 'UTF-8'),
'lastModifiedBy' => 'Some Name',
'sheetTitle' => 'Report on ' . date('m-d-Y H-i'),
'keywords' => '',
'category' => '',
'landscapeDisplay' => true, // Default: false
'A4' => true, // Default: false - ie : Letter (PHPExcel default)
'RTL' => false, // Default: false - since v1.1
'pageFooterText' => '&RThis is page no. &P of &N pages', // Default: '&RPage &P of &N'
'automaticSum' => true, // Default: false
'decimalSeparator' => ',', // Default: '.'
'thousandsSeparator' => '.', // Default: ','
'rowHeight' => 45, // Default: 15
'headerBorderColor' => 'FF0000', // Default: '000000'
'headerBgColor' => 'CCCCCC', // Default: 'CCCCCC'
'headerTextColor' => '0000FF', // Default: '000000'
'headerHeight' => 30, // Default: 20
'columns' => array(
array('name'=>'id','value'=>'$data->id',),
array('name'=>'cat_id','value'=>'$data->cat->name','filter'=>CatNews::getNewsCatDDL(),),
'title',
) // an array of your CGridColumns
)); ?>
When I choose CatNews, results is true. But when I choose CatNews, then Choose button export to excel. File excel is contained all records. Please tell me how to change my code to export results after filtering? Thanks.