var fs = require("fs");
var express = require("express");
var bodyParser = require('body-parser');
var multer = require("multer");
var XLSX = require('xlsx');
var mysql = require('mysql');var con = mysql.createConnection({
host: "localhost",
user: "root",
password: "root",
database: "excel"
});
var upload = multer();var app = express();
// for parsing application/json
app.use(bodyParser.json());
// for parsing application/xwww-app.use(bodyParser.urlencoded({ extended: true }));
//form-urlencoded
// for parsing multipart/form-data
//app.use(upload.array());
//static folder
app.use(express.static('public'));
app.get('/', function(req, res) {fs.readFile('index.html', 'utf8', function (err,data) {
if (err) {
return console.log(err);
}
//console.log(data);
res.write(data)
});
});
app.post("/sendFile", upload.single('fileName'), function(req, res){//text fields
//console.log(req.body);
//file contents//console.log(req.file);
console.log(req.file.originalname);
var name=req.file.originalname;
var workbook = XLSX.readFile(name);
var sheet_name_list = workbook.SheetNames;
var xlData = XLSX.utils.sheet_to_json(workbook.Sheets[sheet_name_list[0]]);
var mydata=JSON.stringify(xlData)
console.log(mydata);
con.connect(function(err){if (err) throw err;
console.log("Connected!");
//Insert a record in the "customers" table:
for(var i=0;i<=xlData.length-1;i++){
var sql = "INSERT INTO excel VALUES ("+xlData[i].patientid + ",'"+
xlData[i].patientname +"','" +xlData[i].patientplace+ "')";
console.log(sql);
con.query(sql, function (err, result) {
if (err) throw err;
console.log("1 record inserted");
});
}
});
// processvar response = 'Do something';
res.json(response);
});app.listen(8000, function () {
console.log('Example app listening on port 8000!')
});
<!DOCTYPE html>
<html>
<head lang="en">
<meta charset="UTF-8">
<title></title>
<script src="upload.js"></script>
</head>
<body><div class="input-field col s6">
<form name="myForm" action="/sendFile" method="post" enctype="multipart/form-data">
<input id="fileName" name="fileName" type="file" class="validate" >
<input type="submit">
</form>
</div>
</body>
No comments:
Post a Comment