使用node读写Excel文件

        const fs = require('fs')
        const xlsx = require('node-xlsx')
        const nodeExcel = require('excel-export')
        // 读取Excel
        let exceldata = xlsx.parse('./' + 'xxx.xlsx')
        let exportData = []
        for (let rowId in exceldata[0]['data']) {
        let row = exceldata[0]['data'][rowId]
         exportData.push(row[0])
        }
        // 导出Excel
        let conf = {} // excel配置
        conf.name = 'sheet' //表格名
        // 列名和类型
        conf.cols = [
        {
         caption: '列名',
        type: 'string',
        },
        ]
        let excelData = new Array()
        for (var i = 0; i < exportData.length; i++) {
        let arr = new Array()
         arr.push(exportData[i])
         excelData.push(arr)
        }
        conf.rows = excelData
        let result = nodeExcel.execute(conf)
        let path = `${__dirname}/exportdata.xlsx`
        fs.writeFile(path, result, 'binary', (err) => {
         err ? console.log(err) : null
        })