Reading a CSV file using JQuery

Reading a CSV file using JQuery

by phsiao2000

HTML

<script src="https://rawgit.com/knrz/CSVjs/master/csv.js"></script>
<input type="file" name="filename" id="filename">
<div id="csvimporthint"></div>

JavaScript

$("#filename").change(function (e) {
    var ext = $("input#filename").val().split(".").pop().toLowerCase();

    if ($.inArray(ext, ["csv"]) == -1) {
        alert('Upload CSV');
        return false;
    }

    if (e.target.files != undefined) {
        var reader = new FileReader();
        reader.onload = function (e) {
            res = e.target.result;
            var csv = new CSV({
                header: true,
                stream: function(r){console.log(r);}
            });
            var r = csv.parse(res);
            console.log(r);
        };
        reader.readAsText(e.target.files.item(0));
    }

    return false;

});