insert xl data into mysql and generate pdf of xl data

var XLSX = require('xlsx')

var workbook = XLSX.readFile('excel1.xlsx');

var sheet_name_list = workbook.SheetNames;

var xlData = XLSX.utils.sheet_to_json(workbook.Sheets[sheet_name_list[0]]);

console.log(xlData)

var mysql = require('mysql');

var pdf=require('pdfkit');

var fs=require('fs');

var myDoc=new pdf;

var hi = JSON.stringify(xlData);

myDoc.pipe(fs.createWriteStream('node.pdf'));

myDoc.font('Times-Roman').fontSize(10).text(hi,10,10);

myDoc.end();

console.log(myDoc);

var con = mysql.createConnection({

host: "localhost",

user: "root",

password: "root",

database: "excel"

});

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");

});

}

});