Pages

(Node) Read from xlsx file

//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

No comments:

Post a Comment