<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
	<title>jQuery Grid Plugin - jqGrid - Topic: Jqgrid table export to excel</title>
	<link>http://www.trirand.com/blog/?page_id=393/jqgrid-roadmap/jqgrid-table-export-to-excel</link>
	<description><![CDATA[Grid plugin]]></description>
	<generator>Simple:Press Version 5.7.5.3</generator>
	<atom:link href="http://www.trirand.com/blog/?page_id=393/jqgrid-roadmap/jqgrid-table-export-to-excel/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>khurram_619 on Jqgrid table export to excel</title>
        	<link>http://www.trirand.com/blog/?page_id=393/jqgrid-roadmap/jqgrid-table-export-to-excel#p25701</link>
        	<category>jqGrid Roadmap</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/jqgrid-roadmap/jqgrid-table-export-to-excel#p25701</guid>
        	        	<description><![CDATA[<p><span style="font-size: small;">hiiii</span></p>
<p>i try to export jqgrid table into excel file, but i have an error.<br />THIS IS MY CODE</p>
<p>JS</p>
<p><span style="font-size: small;"><br />function jqgridtable()<br />{&#160; &#160;&#160;<br />&#160; &#160;&#160;var url=&#39;index.php?r=advertise/tableJSON&#39;;<br />&#160; &#160;&#160;<br />&#160; &#160;&#160;$.ajax({<br />&#160; &#160; &#160; &#160;type: "GET",<br />&#160; &#160; &#160; &#160;url: url,&#160;<br />&#160; &#160; &#160; &#160;dataType: "json",<br />&#160; &#160; &#160; &#160;success: function(result){<br />&#160; &#160; &#160; &#160; &#160; &#160;var&#160; &#160;table=&#39;list&#39;,<br />&#160; &#160; &#160; &#160; &#160;&#160; &#160;&#160;&#160; &#160;&#160;pager=&#39;pager&#39;,</span></p>
<p>&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;&#160; &#160;&#160;colM = result.colModelList,<br />&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;&#160; &#160;&#160;cap&#160; = result.caption;<br />&#160; &#160; &#160; &#160; &#160; &#160;&#160; &#160;&#160;&#160; &#160;&#160;colN = result.columnNames;<br />&#160; &#160; &#160; &#160; &#160; &#160;&#160; &#160;&#160;&#160; &#160;&#160;rowS = result.rows;<br />&#160; &#160; &#160; &#160; &#160; &#160; &#160;&#160;&#160; &#160;&#160;listjqgrid(table,pager,colN,colM,rowS,cap);</p>
<p>&#160; &#160; &#160; &#160; &#160; &#160; &#160;&#160;&#160; &#160;&#160;jQuery("#"+table).jqGrid(&#39;navButtonAdd&#39;,&#39;#&#39;+pager,{<br />&#160; &#160; &#160; &#160; &#160; &#160;&#160; &#160;&#160;&#160; &#160; &#160; &#160;&#160;&#160; &#160; title:&#39;export to excel&#39;,<br />&#160; &#160; &#160; &#160; &#160; &#160;&#160; &#160;&#160; &#160; &#160;&#160;&#160; &#160;&#160; &#160;&#160;buttonicon:&#39;ui-icon-newwin&#39;,<br />&#160; &#160; &#160; &#160; &#160; &#160;&#160; &#160;&#160; &#160; &#160;&#160;&#160; &#160; &#160; &#160; onClickButton : function () {&#160;<br />&#160; &#160; &#160; &#160; &#160; &#160;&#160; &#160;&#160;&#160; &#160; &#160; &#160;&#160; &#160;&#160;&#160; &#160; &#160; &#160; $.post(&#39;index.php?r=advertise/excel&#39;, {r:rowS, n:colN});&#160; &#160;&#160;<br />&#160; &#160; &#160; &#160; &#160; &#160;&#160; &#160;&#160;&#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; }<br />&#160; &#160; &#160; &#160; &#160; &#160;&#160; &#160;&#160;&#160; &#160;&#160;});<br />&#160; &#160; &#160; &#160;}<br />&#160; &#160;&#160;&#160; &#160;&#160;<br />&#160; &#160;&#160;});<br />}</p>
</p>
<p><span style="font-size: small;">phpfile</span></p>
</p>
<p><span style="font-size: small;">&#160;&#160;&#160;&#160; &#160;&#160;$names=$_REQUEST[&#39;n&#39;];<br />&#160; &#160;&#160;&#160; &#160;&#160;$rows=$_REQUEST[&#39;r&#39;];<br />&#160; &#160;&#160;&#160; &#160;&#160;<br />&#160; &#160;&#160;&#160; &#160;&#160;error_reporting(E_ALL);</span></p>
<p>&#160; &#160;&#160;&#160; &#160;&#160;$phpExcelPath = Yii::getPathOfAlias(&#39;ext.phpexcel.Classes&#39;);<br />&#160; &#160;&#160;&#160; &#160;&#160;spl_autoload_unregister(array(&#39;YiiBase&#39;,&#39;autoload&#39;));&#160;<br />&#160; &#160;&#160;&#160; &#160;&#160;include($phpExcelPath . DIRECTORY_SEPARATOR . &#39;PHPExcel.php&#39;);</p>
<p>&#160; &#160;&#160;&#160; &#160;&#160;$objPHPExcel = new PHPExcel();</p>
<p>&#160; &#160;&#160;&#160; &#160;&#160;//Set properties<br />&#160; &#160;&#160;&#160; &#160;&#160;$objPHPExcel-&#62;getProperties()-&#62;setCreator("Khurram Bashir")<br />&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;-&#62;setTitle("Office 2007 XLS Test Document")<br />&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;-&#62;setSubject("Office 2007 XLS Test Document")<br />&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;-&#62;setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")<br />&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;-&#62;setKeywords("office 2007 php")<br />&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;-&#62;setCategory("Test result file");</p>
<p>&#160; &#160;&#160;&#160; &#160;&#160;$objPHPExcel-&#62;setActiveSheetIndex(0)<br />&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160; &#160; &#160; &#160; &#160; -&#62;setCellValue(&#39;A1&#39;, &#39;hi&#39;)<br />&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160; &#160; &#160; &#160; &#160; -&#62;setCellValue(&#39;A2&#39;, &#39;hiiii&#39;)<br />&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160; &#160; &#160; &#160; &#160; -&#62;setCellValue(&#39;B1&#39;, &#39;hi&#39;)<br />&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160; &#160; &#160; &#160; &#160; -&#62;setCellValue(&#39;B2&#39;, &#39;hiiiii&#39;);<br />&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160; &#160; &#160; &#160; &#160;&#160;<br />&#160; &#160;&#160;&#160; &#160;&#160;</p>
<p>&#160; &#160;&#160;&#160; &#160;&#160;// Rename sheet<br />&#160; &#160;&#160;&#160; &#160;&#160;$objPHPExcel-&#62;getActiveSheet()-&#62;setTitle(&#39;Simple&#39;);</p>
<p>&#160; &#160;&#160;&#160; &#160;&#160;// Set active sheet index to the first sheet, so Excel opens this as the first sheet<br />&#160; &#160;&#160;&#160; &#160;&#160;$objPHPExcel-&#62;setActiveSheetIndex(0);<br />&#160; &#160;&#160;&#160; &#160;&#160;<br />&#160; &#160;&#160;&#160; &#160;&#160;// Redirect output to a client&#8217;s web browser (Excel5)<br />&#160; &#160;&#160;&#160; &#160;&#160;header(&#39;Content-Type: application/vnd.ms-excel&#39;);<br />&#160; &#160;&#160;&#160; &#160;&#160;header("Content-Type: application/force-download");<br />&#160; &#160;&#160;&#160; &#160;&#160;header(&#39;Content-Disposition: attachment;filename="01simple.xls"&#39;);<br />&#160; &#160;&#160;&#160; &#160;&#160;header("Pragma: ");&#160;&#160;<br />&#160; &#160;&#160;&#160; &#160;&#160;header("Cache-Control: ");&#160;<br />&#160; &#160;&#160;&#160; &#160;&#160;<br />&#160; &#160;&#160;&#160; &#160;&#160;$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, &#39;Excel5&#39;);<br />&#160; &#160;&#160;&#160; &#160;&#160;<br />&#160; &#160;&#160;&#160; &#160;&#160;<strong>$objWriter-&#62;save(&#39;php://output&#39;);</strong><br />&#160; &#160;&#160;&#160; &#160;&#160;Yii::app()-&#62;end();<br />&#160; &#160;&#160;&#160; &#160;&#160;<br />&#160; &#160; &#160; &#160;// Once we have finished using the library, give back the&#160;<br />&#160; &#160; &#160; &#160;// power to Yii...&#160;<br />&#160; &#160; &#160; &#160;spl_autoload_register(array(&#39;YiiBase&#39;,&#39;autoload&#39;));<br />&#160; &#160;&#160;}</p>
</p>
<p><span style="font-size: small;">after execute this code don&#39;t give me code error and not out to save the file.</span></p>
<p>i have watched with Firebug and give me a response</p>
</p>
<p><span style="font-size: small;">ï¿½ï¿½à¡±ï¿½;'ï¿½ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½&#160; &#160;&#160;ï¿½<br />ï¿½ï¿½Bï¿½=ï¿½%r8X"1ï¿½ï¿½Calibriï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ ï¿½&#160; &#160;&#160;ï¿½ ï¿½&#160; &#160;&#160;ï¿½ï¿½ï¿½ï¿½ï¿½8ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½3fï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ffï¿½ï¿½ï¿½fï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½Ì™ï¿½ï¿½Ì™3fï¿½3ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½ï¿½fffï¿½ï¿½ï¿½ï¿½3f3ï¿½f333ï¿½3ï¿½3f33ï¿½333ï¿½'Simpleï¿½ï¿½gï¿½ï¿½ï¿½ciao</span></p></p>
]]></description>
        	        	<pubDate>Tue, 17 Jan 2012 18:39:10 +0200</pubDate>
        </item>
</channel>
</rss>