1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
/* xlsx.js (C) 2013-present SheetJS -- http://sheetjs.com *//* eslint-env browser *//* global XLSX *//* exported SheetJSExportService, SheetJSImportDirective */function SheetJSExportService(uiGridExporterService) {
  function exportSheetJS(gridApi, wopts) {    var columns = uiGridExporterService.getColumnHeaders(gridApi.grid, 'all');    var data = uiGridExporterService.getData(gridApi.grid, 'all', 'all');
    var fileName = gridApi.grid.options.filename || 'SheetJS';    fileName += wopts.bookType ? "." + wopts.bookType : '.xlsx';
    var sheetName = gridApi.grid.options.sheetname || 'Sheet1';
    var wb = XLSX.utils.book_new(), ws = uigrid_to_sheet(data, columns);    XLSX.utils.book_append_sheet(wb, ws, sheetName);    XLSX.writeFile(wb, fileName);  }
  var service = {};  service.exportXLSB = function exportXLSB(gridApi) { return exportSheetJS(gridApi, { bookType: 'xlsb', bookSST: true, type: 'array' }); };  service.exportXLSX = function exportXLSX(gridApi) { return exportSheetJS(gridApi, { bookType: 'xlsx', bookSST: true, type: 'array' }); }
  return service;
  /* utilities */  function uigrid_to_sheet(data, columns) {    var o = [], oo = [], i = 0, j = 0;
    /* column headers */    for(j = 0; j < columns.length; ++j) oo.push(get_value(columns[j]));    o.push(oo);
    /* table data */    for(i = 0; i < data.length; ++i) {      oo = [];      for(j = 0; j < data[i].length; ++j) oo.push(get_value(data[i][j]));      o.push(oo);    }    /* aoa_to_sheet converts an array of arrays into a worksheet object */    return XLSX.utils.aoa_to_sheet(o);  }
  function get_value(col) {    if(!col) return col;    if(col.value) return col.value;    if(col.displayName) return col.displayName;    if(col.name) return col.name;    return null;  }}
function SheetJSImportDirective() {  return {    scope: { opts: '=' },    link: function($scope, $elm) {      $elm.on('change', function(changeEvent) {        var reader = new FileReader();
        reader.onload = function(e) {          /* read workbook */          var ab = e.target.result;          var wb = XLSX.read(ab);
          /* grab first sheet */          var wsname = wb.SheetNames[0];          var ws = wb.Sheets[wsname];
          /* grab first row and generate column headers */          var aoa = XLSX.utils.sheet_to_json(ws, {header:1, raw:false});          var cols = [];          for(var i = 0; i < aoa[0].length; ++i) cols[i] = { field: aoa[0][i] };
          /* generate rest of the data */          var data = [];          for(var r = 1; r < aoa.length; ++r) {            data[r-1] = {};            for(i = 0; i < aoa[r].length; ++i) {              if(aoa[r][i] == null) continue;              data[r-1][aoa[0][i]] = aoa[r][i];            }          }
          /* update scope */          $scope.$apply(function() {            $scope.opts.columnDefs = cols;            $scope.opts.data = data;          });        };
        reader.readAsArrayBuffer(changeEvent.target.files[0]);      });    }  };}