Search Posts

Category: export

Angular excel export

Here ,I am calling my node program and getting data from MYSQL and on click exporting in excel. $scope.exportToExcel=function(){ $http.get(“/getDetails”).then(function(response){ console.log(response.data) $scope.details = response.data[1].data; // here you will get data },function(res){ console.log(“Error”,res) //error occured }); $scope.exportToExcel=function(tableId){ // ex: ‘#my-table’ var exportHref=Excel.tableToExcel(tableId,’WireWorkbenchDataExport’); $timeout(function(){location.href=exportHref;},100); // trigger download } var myApp=angular.module(‘myApp’,[]); myApp.factory(‘Excel’,function($window){ 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 { tableToExcel:function(tableId,worksheetName){ var table=$(tableId), ctx={worksheet:worksheetName,table:table.html()}, href=uri+base64(format(template,ctx)); return href; } }; }) […]