NodeJS excel 导入（js-xlsx）

js-xlsx github地址：https://github.com/SheetJS/js-xlsx

１、准备 excel文档

２、解析方法

const XLSX = require("xlsx");function importExcel(filePath, callback) {    var data = [];    var err = null;    try {        // Everything went fine        var workbook = XLSX.readFile(filePath);　//整个　excel　文档        var sheetNames = workbook.SheetNames; //获取所有工作薄名        //console.log(sheetNames);        //解析        var sheet1 = workbook.Sheets[sheetNames[0]]; //根据工作薄名获取工作薄        /*         sheet1['!ref']　获取工作薄的有效范围　'A1:C20'         XLSX.utils.decode_range 将有效范围转为　range对象         range: {s: {r:0, c:0}, e: {r:10, 3}}         */        var range = XLSX.utils.decode_range(sheet1['!ref']);        //循环获取单元格值        for(var R = range.s.r; R <= range.e.r; ++R) {            var row = [],flag = false;            for(var C = range.s.c; C <= range.e.c; ++C) {                var row_value = null;                var cell_address = {c:C, r:R}; //获取单元格地址                var cell = XLSX.utils.encode_cell(cell_address); //根据单元格地址获取单元格                if(sheet1[cell]) //获取单元格值                    row_value = sheet1[cell].v;                else                    row_value = '';                row.push(row_value);            }            //判断整行是否都为空，是则去掉            for(var i = 0; i < row.length; i++){                if(row[i] != '') {                    flag = true;                    break;                }            }            if(flag) data.push(row);        }    } catch (e) {        err = '解析出错' + e.toString();    }    callback(err, data);}importExcel('in.xlsx', function (err, data) {    if(err){        console.log(err);    } else {        console.log(data)    }})

３、测试结果

————————╮（╯＿╰）╭————————