forked from zsusac/ReactHTMLTableToExcel
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.js
149 lines (118 loc) · 6.37 KB
/
index.js
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
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
'use strict';
Object.defineProperty(exports, "__esModule", {
value: true
});
var _createClass = function () { function defineProperties(target, props) { for (var i = 0; i < props.length; i++) { var descriptor = props[i]; descriptor.enumerable = descriptor.enumerable || false; descriptor.configurable = true; if ("value" in descriptor) descriptor.writable = true; Object.defineProperty(target, descriptor.key, descriptor); } } return function (Constructor, protoProps, staticProps) { if (protoProps) defineProperties(Constructor.prototype, protoProps); if (staticProps) defineProperties(Constructor, staticProps); return Constructor; }; }();
var _react = require('react');
var _react2 = _interopRequireDefault(_react);
var _propTypes = require('prop-types');
var _propTypes2 = _interopRequireDefault(_propTypes);
function _interopRequireDefault(obj) { return obj && obj.__esModule ? obj : { default: obj }; }
function _classCallCheck(instance, Constructor) { if (!(instance instanceof Constructor)) { throw new TypeError("Cannot call a class as a function"); } }
function _possibleConstructorReturn(self, call) { if (!self) { throw new ReferenceError("this hasn't been initialised - super() hasn't been called"); } return call && (typeof call === "object" || typeof call === "function") ? call : self; }
function _inherits(subClass, superClass) { if (typeof superClass !== "function" && superClass !== null) { throw new TypeError("Super expression must either be null or a function, not " + typeof superClass); } subClass.prototype = Object.create(superClass && superClass.prototype, { constructor: { value: subClass, enumerable: false, writable: true, configurable: true } }); if (superClass) Object.setPrototypeOf ? Object.setPrototypeOf(subClass, superClass) : subClass.__proto__ = superClass; } /* global window, document, Blob */
var propTypes = {
table: _propTypes2.default.string.isRequired,
filename: _propTypes2.default.string.isRequired,
sheet: _propTypes2.default.string.isRequired,
id: _propTypes2.default.string,
className: _propTypes2.default.string,
buttonText: _propTypes2.default.oneOfType([
// Can be either a text or some JSX like an icon
_propTypes2.default.string,
_propTypes2.default.object,
]),
buttonComponent: _propTypes2.default.oneOfType([
// Can be either a text (e.g. 'button') or a React Component
_propTypes2.default.string,
_propTypes2.default.object,
]),
};
var defaultProps = {
id: "button-download-as-xls",
className: "button-download",
buttonText: "Download",
buttonComponent: "button",
};
var ReactHTMLTableToExcel = function (_Component) {
_inherits(ReactHTMLTableToExcel, _Component);
function ReactHTMLTableToExcel(props) {
_classCallCheck(this, ReactHTMLTableToExcel);
var _this = _possibleConstructorReturn(this, (ReactHTMLTableToExcel.__proto__ || Object.getPrototypeOf(ReactHTMLTableToExcel)).call(this, props));
_this.handleDownload = _this.handleDownload.bind(_this);
return _this;
}
_createClass(ReactHTMLTableToExcel, [{
key: 'handleDownload',
value: function handleDownload() {
if (!document) {
if (process.env.NODE_ENV !== 'production') {
console.error('Failed to access document object');
}
return null;
}
if (document.getElementById(this.props.table).nodeType !== 1 || document.getElementById(this.props.table).nodeName !== 'TABLE') {
if (process.env.NODE_ENV !== 'production') {
console.error('Provided table property is not html table element');
}
return null;
}
var table = document.getElementById(this.props.table).outerHTML;
var sheet = String(this.props.sheet);
var filename = String(this.props.filename) + '.xls';
var uri = 'data:application/vnd.ms-excel;base64,';
var template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-mic' + 'rosoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><meta cha' + 'rset="UTF-8"><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:Exce' + 'lWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/>' + '</x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></' + 'xml><![endif]--></head><body>{table}</body></html>';
var context = {
worksheet: sheet || 'Worksheet',
table: table
};
// If IE11
if (window.navigator.msSaveOrOpenBlob) {
var fileData = ['' + ('<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-mic' + 'rosoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><meta cha' + 'rset="UTF-8"><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:Exce' + 'lWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/>' + '</x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></' + 'xml><![endif]--></head><body>') + table + '</body></html>'];
var blobObject = new Blob(fileData);
document.getElementById('react-html-table-to-excel').click()(function () {
window.navigator.msSaveOrOpenBlob(blobObject, filename);
});
return true;
}
var element = window.document.createElement('a');
element.href = uri + ReactHTMLTableToExcel.base64(ReactHTMLTableToExcel.format(template, context));
element.download = filename;
document.body.appendChild(element);
element.click();
document.body.removeChild(element);
return true;
}
}, {
key: 'render',
value: function render() {
var ButtonComponent = this.props.buttonComponent;
return _react2.default.createElement(
ButtonComponent,
{
id: this.props.id,
className: this.props.className,
type: "button",
onClick: this.handleDownload,
},
this.props.buttonText
);
}
}], [{
key: 'base64',
value: function base64(s) {
return window.btoa(unescape(encodeURIComponent(s)));
}
}, {
key: 'format',
value: function format(s, c) {
return s.replace(/{(\w+)}/g, function (m, p) {
return c[p];
});
}
}]);
return ReactHTMLTableToExcel;
}(_react.Component);
ReactHTMLTableToExcel.propTypes = propTypes;
ReactHTMLTableToExcel.defaultProps = defaultProps;
exports.default = ReactHTMLTableToExcel;