Wijmo (Angular) - Sync Export Table into Excel File

Checking if the handler will remain working if you click out of a multiselect in a flexgrid and then back into it.

by Joel Parks

HTML

<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/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.input.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.chart.min.js"></script>
<script src="http://cdn.wijmo.com/5.20161.138/controls/wijmo.grid.filter.min.js"></script>
<script src="http://cdn.wijmo.com/5.latest/interop/angular/wijmo.angular.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/controls/wijmo.xlsx.min.js"></script>
<script src="http://cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js"></script>
<!-- mark this as an Angular application and give it a controller -->
<div ng-app="app" ng-controller="appCtrl">
  <div ng-hide="hidden">
    <wj-flex-grid items-source="ctx.data" control="ctx.flexGrid" item-formatter="itemFormatter" style="height: 400px;margin-top:10px" control="flex">
      <wj-flex-grid-filter></wj-flex-grid-filter>
      <wj-flex-grid-column header="Country" binding="country" width="*"></wj-flex-grid-column>
      <wj-flex-grid-column header="Expenses" binding="expenses" format="c" width="*"></wj-flex-grid-column>
      <wj-flex-grid-column header="Sales" name="Sales"  binding="sales" format="c" width="*">
        <span style="color:green" ng-if="$item.sales > 5000">{{ $item.sales | currency}}</span> 
        <span style="color:red" ng-if="$item.sales < 5000">{{ $item.sales | currency}}</span> 
      </wj-flex-grid-column>
    </wj-flex-grid>
  </div>
  <button class="btn btn-default" ng-click="exportExcel()">Export</button>
  <div class="checkbox">
      <label>
          <input type="checkbox"...

JavaScript

// define app, include Wijmo 5 directives
var app = angular.module('app', ['wj']);

// controller
app.controller('appCtrl', function ($scope) {
//	$scope.itemFormatter = itemFormatter;
	    // create some random data
    var countries = 'Australia,China,UK,USA,Germany,France,S. Korean,Russia'.split(','),
        data = [];
    for (var i = 0; i < countries.length; i++) {
        data.push({
            country: countries[i],
            downloads: Math.round(Math.random() * 20000),
            sales: Math.random() * 10000,
            expenses: Math.random() * 5000,
            date: new Date(2016, i % 12, (i + 10) % 25),
        });
    }
		
    // expose data as a CollectionView to get events
    $scope.data = new wijmo.collections.CollectionView(data);
    
    $scope.ctx = {
        flexGrid: null,
        data: data,
        includeColumnHeader: true,
        customContent: false
    }
    
    $scope.exportExcel = function () {
    	wijmo.grid.xlsx.FlexGridXlsxConverter.save($scope.ctx.flexGrid, { 
      	includeColumnHeaders: $scope.ctx.includeColumnHeader, includeCellStyles: false 
      }, 'FlexGrid.xlsx');
		};
});