node导入数据

node服务器上传文件

1.下载multiparty插件

 npm i multiparty

2.下载node-xlsx

npm i node-xlsx

3.在创建一个根路径upload文件夹
4.在app.js文件中配置路径

app.use('/upload',express.static('upload'))

5.在使用的文件中引入

var multiparty = require('multiparty')
var xlsx = require("node-xlsx")

6.处理数据

router.post("/uploadExcel", (req, res) => {
    const form = new multiparty.Form()
    form.uploadDir = "upload"
    form.parse(req, async (err, formData, excelData) => {
        let dataUrl = excelData.file[0].path
        let data = xlsx.parse(dataUrl)[0].data  //[[],[]]
        let arr = [];//存放数据
        data.forEach(item => {
            arr.push({
                TaskName: item[0],
                sponsor: item[1],
                TaskLeve: item[2],
                TaskStatus: item[3],
                ResponsiblePerson: item[4],
                CoOrganizers: item[5],
                StartDate: item[6],
                EndDate: item[7],
                InformPeople: item[8],
                TaskDescription: item[9],
            })
        })
        arr.forEach(async (item) => {
            await taskModule.create(item)
        })
    })
})