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.
10 readSheet(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 }
47 readSheet(x) { 48 return fs.readFileSync(join(__dirname, './style', x), 'utf8'); 49 }
68 function 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 }
8 export 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 }