JavaScript 读取CSV文件并转为js对象

html部分

<!-- 创建隐藏file input -->
<button type="button" name="seach" onclick="FuncCSVInport()">CSV Import</button> <input type="file" id="csvFileInput" onchange="readCSVFile(this)" /> #csvFileInput{ position: absolute; right: 0px; opacity: 0; }

js部分

<script>
    function csvToObject(csvString){
        var csvarry = csvString.split("\r\n");
        var datas = [];
        var headers = csvarry[0].split(",");
        for(var i = 1;i<csvarry.length;i++){
            var data = {};
            var temp = csvarry[i].split(",");
                 for(var j = 0;j<temp.length;j++){
                     data[headers[j]] = temp[j];
                 }
            datas.push(data);
        }
         return datas;
    }

     function FuncCSVInport() {
         $("#csvFileInput").val("");
         $("#csvFileInput").click();
     }

     function readCSVFile(obj) {
         var reader = new FileReader();
         reader.readAsText(obj.files[0]);
         reader.onload = function () {
               var data = csvToObject(this.result);
                console.log(data);//data为csv转换后的对象
        }
   }
</script>                

 

posted @ 2019-06-05 10:11  exception_d  阅读(13722)  评论(3编辑  收藏  举报