ANGULARJS export html table to excel angularjs - Net-Raft.com

Welcome aboard! We are happy you are here and wish you good net-raft!




Just a Web Code Solution
join us

export html table to excel angularjs


 2664

Show ResultANGULARJS


2

<html ng-app="myApp">
<head>
<script data-require="angular.js@*" data-semver="2.0.0" src="https://code.angularjs.org/1.4.8/angular.js"></script>
<script data-require="jquery@*" data-semver="2.1.4" src="https://code.jquery.com/jquery-2.1.4.js"></script>
</head>

<body ng-controller="MyCtrl">
<button class="btn btn-link" ng-click="exportToExcel('#tableToExport')">
Export to Excel
</button>

<div id="tableToExport">

<table border="1">
<thead>
<tr class="table-header">
<th></th>
<th>Technology</th>
<th>Side</th>
</tr>
</thead>
<tbody>
<tr>
<td>1</td>
<td>Angularjs</td>
<td>client</td>
</tr>
<tr>
<td>2</td>
<td>PHP</td>
<td>server</td>
</tr>
<tr>
<td>3</td>
<td>Javascript</td>
<td>client</td>
</tr>
</tbody>
</table>

</div>

<script>
// not works for IE
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;
}
};
})

.controller('MyCtrl',function(Excel,$timeout,$scope){
$scope.exportToExcel=function(tableId){
var exportHref=Excel.tableToExcel(tableId,'WireWorkbenchDataExport');
$timeout(function(){location.href=exportHref;},100);
}

});
</script>
</body>
</html>


By        
The power of the user (%)
80%



The most helpful ANGULARJS solutions

How to get client ip address using angularjs ?How to get client ip address using angularjs ?ANGULARJS

Click to see more ...

  19.6K     2.8K

How to get city from ip address with angularjs ?How to get city from ip address with angularjs ?ANGULARJS

Click to see more ...

  7.7K     1.4K

how to get client machine name and user name using angularjs ?how to get client machine name and user name using angularjs ?ANGULARJS

Click to see more ...

  11.9K     796

How to get local client ip address using angularjs ?How to get local client ip address using angularjs ?ANGULARJS

Click to see more ...

  5.8K     562

get client country using angularjs ?get client country using angularjs ?ANGULARJS

Click to see more ...

  2.9K     477

get region angularjsget region angularjsANGULARJS

Click to see more ...

  2.5K     414

How to get value from a href using angularjs ?How to get value from a href using angularjs ?ANGULARJS

Click to see more ...

  2.1K     369

how to fill a list from an another file in json format using angularjs ?how to fill a list from an another file in json format using angularjs ?ANGULARJS

Click to see more ...

  2.1K     352

How to move the value of checkbox to an html element in angular.js ?How to move the value of checkbox to an html element in angular.js ?ANGULARJS

Click to see more ...

  2.1K     203

get client time zone using angularjs get client time zone using angularjs ANGULARJS

Click to see more ...

  2.2K     201

Welcome aboard!
We are happy you are here and
wish you good net-raft!