Wednesday, October 22, 2014

Export Excel by using jquery

Posted by Gnani Palepu  |  1 comment

 if you want more related search please click here  
 please help to other  
 http://scriptquery.blogspot.in/  
 Export Excel by using jquery  
 ---------------------------  
 simple  
 Step1): for Export Excel  
 -------  
 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: for Export Excel  
 -------  
  tableToExcel("give your table id here"); // call the function where evere you want.  
 happy coding for Export Excel.  
 if you want more related search please click here  
 please help to other  
 http://scriptquery.blogspot.in/  

10:46 PM Share:

1 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