您当前的位置： 首页 > 学无止境 > JS经典实例 网站首页JS经典实例

js读取excel JavaScript读取excel

发布时间：2022-05-26 08:45:34编辑：雪饮阅读（）

  function import_expert(obj){
        console.log("obj",obj);
        var files=obj.files;

        var fileReader = new FileReader();
        fileReader.onload = function(ev) {
            try {
                var data = ev.target.result
                var workbook = XLSX.read(data, {
                    type: 'binary'
                }) // 以二进制流方式读取得到整份excel表格对象
                var persons = []; // 存储获取到的数据
            } catch (e) {
                console.log('文件类型不正确');
                return;
            }
            // 表格的表格范围，可用于判断表头是否数量是否正确
            var fromTo = '';
            // 遍历每张表读取
            for (var sheet in workbook.Sheets) {
                if (workbook.Sheets.hasOwnProperty(sheet)) {
                    fromTo = workbook.Sheets[sheet]['!ref'];
                    console.log(fromTo);
                    persons = persons.concat(XLSX.utils.sheet_to_json(workbook.Sheets[sheet]));
                    //break; // 如果只取第一张表，就取消注释这行
                }
            }
            //在控制台打印出来表格中的数据
            console.log("persons",persons);
            var expert_list=[];
            persons.forEach(function(val,index,arr){
                if(index>0){
                    var account=val.__EMPTY;
                    var industry=9;
                    var user_name=val.__EMPTY_1;
                    var phone=val.__EMPTY_6;
                    var working_years=0;
                    var introduce=val.__EMPTY_5;
                    var gender=val.__EMPTY_7;
                    if(gender=="男") gender=1;
                    if(gender=="女") gender=2;
                    var corporate_identity=val.__EMPTY_2;
                    var user_type=2;
                    var createtime=parseInt(new Date().getTime()/1000);
                    var password=MD5("Zhku@123");

                    expert_list.push({
                        account,industry,
                        user_name,phone,
                        working_years,introduce,
                        gender,corporate_identity,
                        user_type,createtime,password
                    });
                }
            });
            console.log("专家列表",expert_list);
            //$("#area").val(JSON.stringify(persons));
        };
        // 以二进制方式打开文件
        fileReader.readAsBinaryString(files[0]);
    }

用到的md5的js及xlsx的js：

md5_with_xlsx.rar

0aba1aeaf5f5667480493f23b8fc5b05.rar (265.09 KB)