4 examples of 'read excel file in js' in JavaScript

Every line of 'read excel file in js' code snippets is scanned for vulnerabilities by our powerful machine learning engine that combs millions of open source libraries, ensuring your JavaScript code is secure.

All examples are scanned by Snyk Code

By copying the Snyk Code Snippets you agree to
10readSheet(sheet){
11 let excel = this.readFile();
12 if(typeof sheet === 'number'){
13 return XLSX.utils.sheet_to_json(excel.Sheets[excel.SheetNames[sheet]]);
14 } else if(typeof sheet === 'string'){
15 return XLSX.utils.sheet_to_json(excel.Sheets[sheet]);
16 } else {
17 return null;
18 }
19}
47readSheet(x) {
48 return fs.readFileSync(join(__dirname, './style', x), 'utf8');
49}
68function excel2json(files: File[], cb: CallBack, defval = ''): any {
69 // https://caniuse.com/#search=FileReader
70 let reader = new FileReader();
71
72 if (!files || files.length === 0) {
73 return;
74 }
75 let file = files[0];
76
77 reader.onerror = (err: any) => {
78 console.error('File read error: ', err);
79 };
80
81 reader.onload = (e: any) => {
82 // pre-process data
83 let binary = '';
84 let bytes = new Uint8Array(e.target.result);
85 let length = bytes.byteLength;
86
87 for (let i = 0; i < length; i++) {
88 binary += String.fromCharCode(bytes[i]);
89 }
90
91 // read workbook
92 let wb = XLSX.read(binary, {type: 'binary'});
93
94 let res = {};
95
96 for (let name of wb.SheetNames) {
97 let ws = wb.Sheets[name];
98 res[name] = XLSX.utils.sheet_to_json(ws, {defval});
99 }
100
101 if (typeof cb === 'function') {
102 cb(res);
103 }
104 };
105
106 reader.readAsArrayBuffer(file);
107}
8export function readFirstSheet(data: any, options: XLSX.ParsingOptions): any[][] {
9 const wb: XLSX.WorkBook = read(data, options);
10 const ws: XLSX.WorkSheet = wb.Sheets[wb.SheetNames[0]];
11 return sheet_to_json(ws, { header: 1, raw: true });
12}

Related snippets