123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139
import * as XLSX from 'xlsx';import * as fs from 'fs';
const version: string = XLSX.version;
const SSF = XLSX.SSF;
const read_opts: XLSX.ParsingOptions = {	type: "buffer",	raw: false,	cellFormula: false,	cellHTML: false,	cellNF: false,	cellStyles: false,	cellText: false,	cellDates: false,	dateNF: "yyyy-mm-dd",	sheetStubs: false,	sheetRows: 3,	bookDeps: false,	bookFiles: false,	bookProps: false,	bookSheets: false,	bookVBA: false,	password: "",	WTF: false};
const write_opts: XLSX.WritingOptions = {	type: "buffer",	cellDates: false,	bookSST: false,	bookType: "xlsx",	sheet: "Sheet1",	compression: false,	Props: {		Author: "Someone",		Company: "SheetJS LLC"	}};
const wb1 = XLSX.readFile("sheetjs.xls", read_opts);XLSX.writeFile(wb1, "sheetjs.new.xlsx", write_opts);
read_opts.type = "binary";const wb2 = XLSX.read("1,2,3\n4,5,6", read_opts);write_opts.type = "binary";const out2 = XLSX.write(wb2, write_opts);
read_opts.type = "buffer";const wb3 = XLSX.read(fs.readFileSync("sheetjs.xlsx"), read_opts);write_opts.type = "base64";const out3 = XLSX.write(wb3, write_opts);write_opts.type = "array";const out4 = XLSX.write(wb3, write_opts);
const ws1 = XLSX.utils.aoa_to_sheet([    "SheetJS".split(""),    [1,2,3,4,5,6,7],    [2,3,4,5,6,7,8]], {	dateNF: "yyyy-mm-dd",	cellDates: true,	sheetStubs: false});
const ws1b = XLSX.utils.aoa_to_sheet([ "SheetJS".split("") ]);XLSX.utils.sheet_add_aoa(ws1b, [[1,2], [2,3], [3,4]], {origin: "A2"});XLSX.utils.sheet_add_aoa(ws1b, [[5,6,7], [6,7,8], [7,8,9]], {origin:{r:1, c:4}});XLSX.utils.sheet_add_aoa(ws1b, [[4,5,6,7,8,9,0]], {origin: -1});
const ws2 = XLSX.utils.json_to_sheet([    {S:1,h:2,e:3,e_1:4,t:5,J:6,S_1:7},    {S:2,h:3,e:4,e_1:5,t:6,J:7,S_1:8}], {	header:["S","h","e","e_1","t","J","S_1"],	cellDates: true,	dateNF: "yyyy-mm-dd"});
const ws2b = XLSX.utils.json_to_sheet([  { A:"S", B:"h", C:"e", D:"e", E:"t", F:"J", G:"S" },  { A: 1,  B: 2,  C: 3,  D: 4,  E: 5,  F: 6,  G: 7  },  { A: 2,  B: 3,  C: 4,  D: 5,  E: 6,  F: 7,  G: 8  }], {header:["A","B","C","D","E","F","G"], skipHeader:true});
const ws2c = XLSX.utils.json_to_sheet([  { A: "S", B: "h", C: "e", D: "e", E: "t", F: "J", G: "S" }], {header: ["A", "B", "C", "D", "E", "F", "G"], skipHeader: true});XLSX.utils.sheet_add_json(ws2c, [  { A: 1, B: 2 }, { A: 2, B: 3 }, { A: 3, B: 4 }], {skipHeader: true, origin: "A2"});XLSX.utils.sheet_add_json(ws2c, [  { A: 5, B: 6, C: 7 }, { A: 6, B: 7, C: 8 }, { A: 7, B: 8, C: 9 }], {skipHeader: true, origin: { r: 1, c: 4 }, header: [ "A", "B", "C" ]});XLSX.utils.sheet_add_json(ws2c, [  { A: 4, B: 5, C: 6, D: 7, E: 8, F: 9, G: 0 }], {header: ["A", "B", "C", "D", "E", "F", "G"], skipHeader: true, origin: -1});
const tbl = {}; /* document.getElementById('table'); */const ws3 = XLSX.utils.table_to_sheet(tbl, {	raw: true,	cellDates: true,	dateNF: "yyyy-mm-dd",	sheetRows: 1});
const obj1 = XLSX.utils.sheet_to_formulae(ws1);
const str1: string = XLSX.utils.sheet_to_csv(ws2, {	FS: "\t",	RS: "|",	dateNF: "yyyy-mm-dd",	strip: true,	blankrows: true,	skipHidden: true});
const html1: string = XLSX.utils.sheet_to_html(ws3, {	editable: false});
const arr1: object[] = XLSX.utils.sheet_to_json(ws1, {	raw: true,	range: 1,	header: "A",	dateNF: "yyyy-mm-dd",	defval: 0,	blankrows: true});
const arr2: any[][] = XLSX.utils.sheet_to_json<any[][]>(ws2, {	header: 1});
const arr3: any[] = XLSX.utils.sheet_to_json(ws3, {	header: ["Sheet", "JS", "Rocks"]});