//npm install xlsx
if(typeof require !== 'undefined') XLSX = require('xlsx');
var workbook = XLSX.readFile('test.xlsx');
// Selects the worksheet
var worksheet = workbook.Sheets["Sheet1"];
var range = XLSX.utils.decode_range(worksheet['!ref']);
for(var R = range.s.r; R <= range.e.r; ++R) {
for(var C = range.s.c; C <= range.e.c; ++C) {
var cell_address = {c:C, r:R};
/* if an A1-style address is needed, encode the address */
var cell_ref = XLSX.utils.encode_cell(cell_address);
if(worksheet[cell_ref])
console.log(worksheet[cell_ref].v);
}
}
Reference: https://www.npmjs.com/package/xlsx
if(typeof require !== 'undefined') XLSX = require('xlsx');
var workbook = XLSX.readFile('test.xlsx');
// Selects the worksheet
var worksheet = workbook.Sheets["Sheet1"];
var range = XLSX.utils.decode_range(worksheet['!ref']);
for(var R = range.s.r; R <= range.e.r; ++R) {
for(var C = range.s.c; C <= range.e.c; ++C) {
var cell_address = {c:C, r:R};
/* if an A1-style address is needed, encode the address */
var cell_ref = XLSX.utils.encode_cell(cell_address);
if(worksheet[cell_ref])
console.log(worksheet[cell_ref].v);
}
}
Reference: https://www.npmjs.com/package/xlsx
No comments:
Post a Comment