if(typeof require !== 'undefined') XLSX = require('xlsx');

var xlsx = "tmp8704.xlsx";
var url = "extFiles/"+xlsx;
var oReq = new XMLHttpRequest();
oReq.open("GET", url, true);
oReq.responseType = "arraybuffer";
var dataXLS;

oReq.onload = function(e) {
var arraybuffer = oReq.response;

/* convert data to binary string */
var data = new Uint8Array(arraybuffer);
var arr = new Array();

for(var i = 0; i != data.length; ++i) arr[i] = String.fromCharCode(data[i]);
var bstr = arr.join("");

/* Call XLSX */
var workbook = XLSX.read(bstr, {type:"binary"});
var first_sheet_name = workbook.SheetNames[0];
/* Get worksheet */
var worksheet = workbook.Sheets[first_sheet_name];

dataXLS = XLSX.utils.sheet_to_json(worksheet, {header:1});

var mysql = require("mysql");

var connection = mysql.createConnection({
  host: 'xxx.xxx.xxx.xxx',
  user: 'muser',
  password: 'massword',
  database: 'matabase'
});

connection.connect((err) => {
if(err) {
  return console.log(err.stack);
}
console.log("Connection succesfully established");
});

for(var x in dataXLS){
  if(parseInt(x)+2 != dataXLS.length) {

      var myNumber = dataXLS[parseInt(x)+2][6];
      console.log("Stelle " + x + " :" + dataXLS[parseInt(x)+2][0] + " " + dataXLS[parseInt(x)+2][1] + " " + parseFloat(myNumber));

      $queryString = "INSERT INTO `articles` (articleno,text,price) VALUES ("+parseInt(dataXLS[parseInt(x)+2][0])+",'"+dataXLS[parseInt(x)+2][1]+"',"+parseFloat(myNumber)+");";


      connection.query($queryString, (err, rows, fields) => {
        if(err) {
          return console.log("An error ocurred with the query", err);
        }
      });

  } else {
    console.log(parseInt(x)+2);
    console.log(dataXLS.length); //19610
    break;
  }
}

connection.end(() => {
  console.log("Connection successfully closed");
});
}

oReq.send();