forked from protobi/js-xlsx
-
Notifications
You must be signed in to change notification settings - Fork 0
/
example3.js
42 lines (35 loc) · 880 Bytes
/
example3.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
var XLSX = require('./');
var wb = {};
wb.Sheets = {};
wb.Props = {};
wb.SSF = {};
wb.SheetNames = [];
var ws = {
"!cols": []
};
var range = {
s: {c: 0, r: 0},
e: {c: 0, r: 0}
};
var cell;
for (var r = 0; r < 6; r++) {
ws["!cols"].push({wch: 6});
if (range.e.r < r + 1) range.e.r = r + 1;
for (var c = 0; c < 6; c++) {
if (range.e.c < c) range.e.c = c;
cell_ref = XLSX.utils.encode_cell({c: c, r: r});
cell = {v: cell_ref};
ws[cell_ref] = cell;
}
}
ws["!ref"] = XLSX.utils.encode_range(range);
wb.SheetNames.push("Sheet1");
wb.Sheets["Sheet1"] = ws;
wb.SheetNames.push("Sheet2");
wb.Sheets["Sheet2"] = JSON.parse(JSON.stringify(ws))
// workbook options
var wopts = {bookType: "xlsx"};
//console.log(JSON.stringify(wb, null,4))
var OUTFILE = '/tmp/example.xlsx';
XLSX.writeFile(wb, OUTFILE, wopts);
console.log("Results written to " + OUTFILE)