JavaScript读取.xlsx文件为json

2020-08-26 分类：前端之旅 / 后端之路阅读(1858) 评论(0)

代码备份 js 部分

$(document).ready(function(){
    $("#fileUploader").change(function(evt){
      var selectedFile = evt.target.files[0];
      var reader = new FileReader();
      // 读取上传文件为二进制
      reader.readAsBinaryString(selectedFile);
      reader.onload = function(event) {
        var data = event.target.result;
        var workbook = XLSX.read(data, {
          type: 'binary'
        });
        workbook.SheetNames.forEach(function(sheetName) {
          var XL_row_object = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);
          if (XL_row_object.length > 0) {
            console.log(XL_row_object)
          }
        })
      };
      reader.onerror = function(event) {
        console.error("File could not be read! Code " + event.target.error.code);
      };
    });
  });

$(document).ready(function(){

$("#fileUploader").change(function(evt){

var selectedFile = evt.target.files[0];

var reader = new FileReader();

// 读取上传文件为二进制

reader.readAsBinaryString(selectedFile);

reader.onload = function(event) {

var data = event.target.result;

var workbook = XLSX.read(data, {

type: 'binary'

});

workbook.SheetNames.forEach(function(sheetName) {

var XL_row_object = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);

if (XL_row_object.length > 0) {

console.log(XL_row_object)

}

})

};

reader.onerror = function(event) {

console.error("File could not be read! Code " + event.target.error.code);

};

});

html 部分

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
<script src="http://libs.baidu.com/jquery/2.0.0/jquery.min.js"></script>
<script type="text/javascript" src="http://cdn.bootcdn.net/ajax/libs/xlsx/0.16.6/xlsx.full.min.js"></script>
</head>
<body>
<div class="body">
  <input type="file" id="fileUploader" name="fileUploader" accept=".xls, .xlsx"/>
</div>
</body>
</html>