Wijmo 5 [Flex Sheet]

GetCellvalue

by Joel Parks

HTML

<link rel="stylesheet" href="http://cdn.wijmo.com/5.20162.198/styles/wijmo.min.css">
<script src="http://cdn.wijmo.com/5.20162.198/controls/wijmo.min.js"></script>
<script src="http://cdn.wijmo.com/5.20162.198/controls/wijmo.input.min.js"></script>
<script src="http://cdn.wijmo.com/5.20162.198/controls/wijmo.grid.min.js"></script>
<script src="http://cdn.wijmo.com/5.20162.198/controls/wijmo.grid.filter.min.js"></script>
<script src="http://cdn.wijmo.com/5.20162.198/controls/wijmo.grid.sheet.min.js"></script>
<script src="http://cdn.wijmo.com/5.20162.198/controls/wijmo.xlsx.min.js"></script>
<script src="http://cdn.wijmo.com/5.20162.198/controls/wijmo.grid.xlsx.min.js"></script>
<script src="http://cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js"></script>
<script src="http://cdn.wijmo.com/5.20162.198/interop/angular/wijmo.angular.min.js"></script>
 <div ng-app="app" ng-controller="appCtrl">
        <button ng-click="save()">Save</button>
        <button ng-click="cellLog()">Change Cell</button>
        <button ng-click="logProperties()">Log Properties</button>
        <wj-flex-sheet control="flexSheet" selected-sheet-index="1" style="height:400px;">
            <wj-sheet name="Country" items-source="data"></wj-sheet>
            <wj-sheet name="Sheet2" items-source="data2"></wj-sheet>
        </wj-flex-sheet>
      
    </div>

CSS

.wj-cell {
  background-color: blue;
}

JavaScript

function getData(value, cmplxData) {
            var countries = 'US,Germany,UK,Japan,Italy,Greece'.split(','),
          data = [];
            for (var i = 0; i < value; i++) {
                data.push({
                    id: i,
                    country: countries[i % countries.length],
                    sales: Math.random() * 1000,
                    expenses: Math.random() * 10000,
                    downloads: Math.random() * 100,
                    complex: dataSelector(i, cmplxData),
                });
            }
            return data;
        }
        
function dataSelector(value, cmplxData){
	if((value%2) === 0){
  	//console.log(cmplxData[0].firstName);
  	return cmplxData[0].firstName;
  }
  //console.log(cmplxData[1].firstName);
  return cmplxData[1].firstName;
}

        var app = angular.module('app', ['wj']);
        app.controller('appCtrl', function ($scope) {
       	 		var cmplxData = [{ firstName: "Bruce", lastName: "Wayne" }, { firstName: "Jimmy", lastName: "John" }];
            $scope.data = new wijmo.collections.CollectionView(getData(50, cmplxData));
            $scope.data2 = new wijmo.collections.CollectionView(getData(50, cmplxData));
            $scope.save = function () {
                var flexSheet = $scope.flexSheet;
                if (flexSheet) {
                    var d = new Date();
                    var m = ('0' + (d.getMonth() + 1)).slice(-2);
                    var e = ('0' + d.getDate()).slice(-2);
                    var h = ('0' + d.getHours()).slice(-2);
                    var i = ('0' + d.getMinutes()).slice(-2);
                    var s = ('0' + d.getSeconds()).slice(-2);                  
                    var flex2 = flexSheet.getCellValue(2, 2, true, flexSheet.sheets[0]);
                    flexSheet.save(flex2 + '_' + d.getFullYear() + '_' + m + '_' + e + '_' + h + '_' + i + '_' + s + '.xlsx');
                }
            };
            // This function allows you to change specific...