EExcelView error on pagination

Yii 1.1 Extensions
1

Hi,

I am using EExcelView extension and it is great !!. When I use pagination, I’m only able to take csv/excel print outs of first page. Not getting other pages.

I’m using CSqlDataProvider to fetch data. I need to take separate print outs of each page. Is there any way ? Am I missing something ?

Please Help.

Thank You,. :)

// Controller

…

$count = Yii::app()->db->createCommand(‘SELECT count(*) FROM parts WHERE qty != 0’)->queryScalar();

$dataProvider = new CSqlDataProvider( "SELECT part_no,name, category FROM parts WHERE qty != 0",

array( ‘keyField’ => ‘part_no’,

      'totalItemCount'=>$count,  


  'pagination'=>


     array(


         'pageSize'=>10,


     ),

) );

…

// View

   ......


$widget = $factory->createWidget( $this,'EExcelView', array(


 'id'=>'e-grid',


 'dataProvider'=>$dataProvider,


 'grid_mode'=>'grid',


 'disablePaging'=>false,


 'filename'=>'parts',


 'columns'=>array(


        'part_no',


        'name',


        'category'


      ),


 'template'=>"{exportbuttons}\n{summary}\n{items}\n{exportbuttons}\n{pager}",


    )); 


........
2

Any one ?? :(

3

Finally I got the solution…

I pass ‘ajaxUpdate’ => false to my EExcelView widget. :)

REFERENCE