Skip to content Skip to sidebar Skip to footer

Convert A Fetched Data In Div From Excel To A Query

The below code fetches data from a csv and presents in to a div as a text but am trying to convert that in to a query on fetch excel import and print then as a query Current outpu

Solution 1:

Try the following

$('#csv').change(function(e) {

  if ((window.FileReader) && (e.target.files != undefined)) {
    var reader = newFileReader();
    reader.onload = function(e) {

      var lineSplit = e.target.result.split("\n");
      var content = [];

      for (var j = 1; j < lineSplit.length; j++) {
        if (lineSplit[j].trim().length > 0) {
          var fourColumnsData = "('" + lineSplit[j].split(',').slice(0, 4).join("','") + "')";

          content.push(fourColumnsData);
        }
      }
      var fileContent = content.join(",");
      $('#result').html(fileContent);

    };

    reader.readAsText(e.target.files.item(0));
  }
});
<scriptsrc="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script><inputid="csv"type="file" /><divid="result"></div>

Post a Comment for "Convert A Fetched Data In Div From Excel To A Query"