Powered by Blogger.

Reading a CSV File Using jQuery


HTML

<input type="file" name="filename" id="filename">

JQuery

Reading CSV


$("#filename").change(function(e) {
 
if (e.target.files != undefined) {
 var reader = new FileReader();
 reader.onload = function(e) {
 var csvval=e.target.result.split("\n");
 var csvvalue=csvval[0].split(",");
 var inputrad="";
 for(var i=0;i<csvvalue.length;i++)
 {
 var temp=csvvalue[i];
 var inputrad=inputrad+" "+temp;
 }
 $("#csvimporthint").html(inputrad);
 $("#csvimporthinttitle").show();
 };
 reader.readAsText(e.target.files.item(0));
 
}
 
return false;
 
});

Checking Whether CSV

var ext = $("input#filename").val().split(".").pop().toLowerCase();
 
if($.inArray(ext, ["csv"]) == -1) {
 alert('Upload CSV');
 return false;
 }

Demo

No comments