EExcelView error on pagination


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’,






) );

// View


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














Any one ?? :(

Finally I got the solution…

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