Wijmo 5 [Export Grid data to excel file]

Grid data export as x=excel file

by Manish Gupta

HTML

<script src="http://code.jquery.com/jquery-2.2.4.min.js"></script>
<script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
<link rel="stylesheet" href="http://cdn.wijmo.com/5.latest/styles/wijmo.min.css">
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.grid.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.xlsx.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/controls/wijmo.grid.xlsx.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/interop/angular/wijmo.angular.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.0.0/jszip.min.js"></script>
 <div ng-app="myApp" ng-controller="gridSelectionController">
  <button class="btn btn-default" ng-click="exportExcel()">Export to Excel</button>
  <div id="grid">
  
  </div>
 <wj-flex-grid items-source="data" control ='flex' style="display:none;">
   
 </wj-flex-grid>
 </div>

JavaScript

var app=angular.module('myApp',['wj']);
  app.controller('gridSelectionController', function ($scope) {
            $scope.data = getData(20);
            function getData(value) {
        var countries = 'India,US,UK,Russia,Japan'.split(',');
        var data = [];
        for (var i = 1; i <= value; i++) {
            data.push({
                id: i,
                country: countries[i % countries.length],
                date: new Date(2016, i % 12, i % 28),
                amount: Math.random()*10000,
                active:parseInt(Math.random()*10) % 3 === 0
            });
        }
        return data;
    }
     $scope.exportExcel = function () {
                var wb=wijmo.grid.xlsx.FlexGridXlsxConverter.save($scope.flex,{includeColumnHeaders:true,includeCellStyles:true});
                console.log(wb)
                var grid = new wijmo.grid.FlexGrid("#grid");
                wijmo.grid.xlsx.FlexGridXlsxConverter.load(grid,wb);
                
            };
           });