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
import * as XLSX from 'xlsx';
console.log(XLSX.version);
const bookType: string = "xlsb";const fn: string = "sheetjsfbox." + bookTypeconst sn: string = "SheetJSFBox";const aoa: any[][] = [ ["Sheet", "JS"], ["Fuse", "Box"], [72, 62] ];

var wb: XLSX.WorkBook = XLSX.utils.book_new();var ws: XLSX.WorkSheet = XLSX.utils.aoa_to_sheet(aoa);XLSX.utils.book_append_sheet(wb, ws, sn);
var payload: string = "";var w2: XLSX.WorkBook;if(typeof process != 'undefined' && process.versions && process.versions.node) {	/* server */	XLSX.writeFile(wb, fn);	w2 = XLSX.readFile(fn)} else {	/* client */	payload = XLSX.write(wb, {bookType: "xlsb", type:"binary"});	w2 = XLSX.read(payload, {type:"binary"});}
var s2: XLSX.WorkSheet = w2.Sheets[sn];console.log(XLSX.utils.sheet_to_csv(s2));