我正在尝试使用nodejs将excel文件中的数据导入到mysql中,就像使用nodejs中的行冒号一样。有什么我可以学习的参考资料,或者nodejs中执行我工作的任何模块或任何示例代码
我在google上搜索过,但我只看到了mongodb和python的解决方案,
发布于 2017-11-23 19:17:42
1.从表单上载csv文件。
2.包含您的配置文件。
看一下下面的代码。
var express = require('express');
var app = express();
var bodyParser = require('body-parser');
var path = require('path');
var http = require('http');
var formidable = require('formidable');
var fs = require('fs');
var csvParser = require('csv-parse');
var cm = require('csv-mysql');
var connection=require('./config');
// Create application/x-www-form-urlencoded parser
var urlencodedParser = bodyParser.urlencoded({ extended: false })
app.use(express.static('public'));
app.get('/csvupload.html', function (req, res) {
res.sendFile(path.resolve("../view/csvupload.html"));
})
app.post('/csvfileupload', urlencodedParser, function (req, res) {
if (req.url == '/csvfileupload') {
var form = new formidable.IncomingForm();
form.parse(req, function (err, fields, files)
{
var oldpath = files.filetoupload.path;
var newpath = 'C:/xampp/htdocs/nodejs/mvc/csvupload/uploads/' + files.filetoupload.name;
fs.rename(oldpath, newpath, function (err) {
if (err) throw err;
res.write('File uploaded and moved!');
res.end();
});
fs.readFile(oldpath, { encoding: 'utf-8' }, function(err, csvData) {
if (err)
{
console.log(err);
}
csvParser(csvData, { delimiter: ',' }, function(err, data) {
if (err)
{
console.log(err);
}
else
{
console.log(data);
var sql = "INSERT INTO customer (id,name,address,designation) VALUES ?";
connection.query(sql, [data], function(err) {
if (err) throw err;
conn.end();
});
}
});
});
});
}
}).listen(8080);
发布于 2018-08-03 06:19:18
我已经开发了一个插件可以做到这一点。下面是npm模块的链接:https://www.npmjs.com/package/xlsx-mysql
和github链接:https://github.com/Rizwaan-Company/xlsx-mysql
示例代码:
const XLSXtoMYSQL = require('xlsx-mysql');
var optionsZ = {
mysql: {
host: '127.0.0.1',
user: 'root',
database: 'test',
password: 'password',
port: '3306'
},
csv: {
delimiter: '+'
}
}
var locationZ = __dirname + '/file.xlsx';
var waitT = 1000;
XLSXtoMYSQL(locationZ,optionsZ,waitT);
https://stackoverflow.com/questions/31651931
复制相似问题