用xlsx.core.min.js上传文件

上传文件js代码:

 

$('#excelfile')
    .on(
      "change",
      function(e) {        var files = e.target.files;
       var fileReader = new FileReader();
       fileReader.onload = function(ev) {
        try {
         var data = ev.target.result, workbook = XLSX
           .read(data, {
            type : 'binary'
           }), // 以二进制流方式读取得到整份excel表格对象
         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; // 如果只取第一张表,就取消注释这行
         }         }         var str = "[";
        var arr;
        for (var j = 0; j < persons.length; j++) {
         arr = persons[j];
         if (j < persons.length - 1) {
          str += JSON.stringify(arr) + ",";
         }
         if (j == persons.length - 1) {
          str += JSON.stringify(arr) + "]";
         }
        }         ds = str;        };
       // 以二进制方式打开文件
       fileReader.readAsBinaryString(files[0]);
      });   <div id='form1'>课程名称<select  name='cname' id='qselect'></select><button  id='qsel'>查询</button>&nbsp;&nbsp;&nbsp;&nbsp;<input type='file' id='excelfile'><button id='upti'>提交</button></div>
上一篇:Python数据分析基础之Excel文件(1)


下一篇:NPOI