Wednesday, February 18, 2015

Simple Export Excel using jquery

Posted by Gnani Palepu  |  No comments


 simple Export excel using jquery  
 -------------------------  
 step 1:  
 ---------  
 this is the jquery   
 var tableToExcel = (function () {  
   var uri = 'data:application/vnd.ms-excel;base64,'  
   , template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>'  
   , base64 = function (s) { return window.btoa(unescape(encodeURIComponent(s))) }  
   , format = function (s, c) { return s.replace(/{(\w+)}/g, function (m, p) { return c[p]; }) }  
   return function (table, name) {  
     if (!table.nodeType) table = document.getElementById(table)  
     var ctx = { worksheet: name || 'Worksheet', table: table.innerHTML }  
     window.location.href = uri + base64(format(template, ctx))  
   }  
 })()  
 step 2:  
 ----------  
 in button click event just past this code  
 change the tablename and title   
   tableToExcel("TableName", "Title");  
 simple happy coding.  

2:03 AM Share:

0 comments:

Get updates in your email box
Complete the form below, and we'll send you the best coupons.

Deliver via FeedBurner
Proudly Powered by Blogger.
back to top