jQuery Grid Plugin - jqGrid - Topic: excel:true not working for me.

davykiash on excel:true not working for me.

Tue, 13 Jul 2010 08:45:34 +0300

After playing around with the code this is what finally worked for me.

$('#export-button').click(function(){
           var postData = $("#list").jqGrid('getGridParam','postData');
            var str='';
           for(i in postData)
                str+=i+"="+postData[i]+"&";
                window.location.href=("<?php echo $this->baseUrl() ?>/user/listpayments?export=excel&"+
               str + new Date().getTime());
           });

At the server side

$file="income_transactions.csv";
           header("Content-Disposition: attachment; filename=" . urlencode($file));
           header("Content-Type: application/force-download");
           header("Content-Type: application/octet-stream");
           header("Content-Type: application/download");
           header("Content-Description: File Transfer");
           header("Content-type: application/csv");
           header("Pragma: no-cache");
           header("Expires: 0");
           $this->_response->setBody($export);

It did the magic for me.

kuafusoft on excel:true not working for me.

Tue, 13 Jul 2010 05:58:22 +0300

I checked the source code of the example case and find that:

jQuery('#grid').jqGrid('navGrid','#pager',{"edit":false,"add":false,"del":false,"search":true,"refresh":true,"view":false,"excel":true},{"drag":true,"resize":true,"closeOnEscape":true,"dataheight":150,"mtype":"POST"},{"drag":true,"resize":true,"closeOnEscape":true,"dataheight":150,"mtype":"POST"},

{"mtype":"POST"},

{"drag":true,"closeAfterSearch":true,"multipleSearch":true},{"drag":true,"resize":true,"closeOnEscape":true,"dataheight":150});

jQuery('#grid').jqGrid('navButtonAdd','#pager',{caption:'',title:'Export to Excel',onClickButton : function(e){
try {
jQuery("#grid").jqGrid('excelExport',{url:'grid.php'});
} catch (e) {
window.location= 'grid.php?oper=excel';
}
}});

davykiash on excel:true not working for me.

Mon, 05 Jul 2010 22:04:06 +0300

Just taken a look at your code.

The main issue is that when I simple add excel:true to my list of pager options the button does not appear.

This seems so obivous yet I can get that button to appear.

What could I be missing?

OlegK on excel:true not working for me.

Mon, 05 Jul 2010 19:06:55 +0300

Hi!

I don't really know this feature, but in the source of the example which you post there are following important part which you probably not use:

jQuery('#grid').jqGrid('navButtonAdd','#pager',
   {caption:'',
   title:'Export to Excel',
   onClickButton : function(e) {
   try {
   jQuery("#grid").jqGrid('excelExport',{url:'grid.php'});
   } catch (e) {
   window.location= 'grid.php?oper=excel';
   }
   }
   });

The code of excelExport function is in the grid.import.js. If you use minimized version of jqGrid you should don't forget to check the corresponding part (Import/Export) before downloading of jqGrid.

Best regards
Oleg

davykiash on excel:true not working for me.

Mon, 05 Jul 2010 10:20:58 +0300

heHi

I have just added the option excel:true to my navigation options but the button is not appearing on my grid pager.

Am using the example http://www.trirand.com/blog/ph.....efault.php

$("#list").jqGrid('navGrid','#pager',
{add:true,addtext:'Add',edit:true,edittext:'Edit',del:true,deltext:'Delete',view:true,viewtext:'View',search:true,searchtext:'Search',

refresh:true,refreshtext:'Refresh',excel:true,exceltext:'Excel'},
               {url:'<?php echo $this->baseUrl() ?>/incomedetails/edit',closeAfterEdit:'true'},
               {url:'<?php echo $this->baseUrl() ?>/incomedetails/add',closeAfterAdd:'true'},
               {url:'<?php echo $this->baseUrl() ?>/incomedetails/delete',closeAfterAdd:'true'}
            );

What am I missing?