Wijmo 5 [Flex Sheet]
GetCellvalue
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>
<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>
JavaScript
function getData(value) {
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,
column: { name: "hello"}
});
}
return data;
}
var app = angular.module('app', ['wj']);
app.controller('appCtrl', function ($scope) {
$scope.data = new wijmo.collections.CollectionView(getData(50));
$scope.data2 = new wijmo.collections.CollectionView(getData(50));
$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');
}
};
});