node操作Excel的例子
npm install一下以下模块
demo.js
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
})