前端读取csv文件内容

来源：互联网发布：淘宝刷单流程360 编辑：程序博客网时间：2024/06/07 17:16
var data = [];var files = document.getElementById("index-info-file").files;var reg = new RegExp(".*,\".*,.*\"$");if(files.length) {    var file = files[0];    var reader = new FileReader();    if(typeof FileReader == 'undefined') {        layer.alert("你的浏览器不支持FileReader接口！", {title: "提示", skin: "layui-layer-molv"});        return;    }    reader.readAsText(file);    reader.onload = function(val) {        var relArr = this.result.split("\r\n");        if(!$.isEmptyObject(relArr) && relArr.length > 1) {            for(var key = 1, len = relArr.length; key < len; key++) {                var values = relArr[key];                if(reg.test(values)) {                    layer.alert("文件内容中有英文逗号，麻烦修改后再上传，含有英文逗号的内容是：" + values, {title: "提示", skin: "layui-layer-molv"});                    return;                }                if(!$.isEmptyObject(values)) {                    var obj = {};                    var objArr = values.split(",");                    obj["name"] = objArr[0];                    obj["fieldName"] = objArr[1];                    obj["targetStepName"] = objArr[2];                    var originalStepName = objArr[3];                    if (!$.isEmptyObject(originalStepName)){                        originalStepName = originalStepName.replace(/，/g, ",");                    }                    obj["originalStepName"] = originalStepName;                    obj["unitId"] = objArr[4];                    obj["dataTypeId"] = objArr[5];                    obj["dataFormatTypeId"] = objArr[6];                    obj["priorityId"] = objArr[7];                    obj["dataTimeId"] = objArr[8];                    obj["description"] = objArr[9];                    data.push(obj);                }            }        }        $("#index-expander-table").bootstrapTable("load", data);        $("#upload-index-file").modal("hide");    }}
阅读全文
0 0