如何在Javascript / HTML5中解析Excel文件 [英] How to parse Excel file in Javascript/HTML5

问题描述

我能够通过 FileReader 读取Excel文件，但它输出文本以及奇怪的字符。我需要逐行阅读 xls 文件，读取每列中的数据并将其转换为JSON。

有谁知道如何逐行读取xls文件。

任何帮助都将得到高度赞赏。

解决方案

将Excel工作表（XLSX格式）数据转换为JSON。你可以添加函数的承诺。

 < script src =https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/ xlsx.js>< /脚本> 
< script src =https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/jszip.js>< / script> 
< script> 
 var ExcelToJSON = function（）{
 
 this.parseExcel = function（file）{
 var reader = new FileReader（）; 
 
 reader.onload = function（e）{
 var data = e.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]）; 
 var json_object = JSON.stringify（XL_row_object）; 
 console.log（json_object）; 
 
}）
 
}; 
 
 reader.onerror = function（ex）{
 console.log（ex）; 
}; 
 
 reader.readAsBinaryString（file）; 
}; 
}; 
< / script> 
  

以下帖子包含XLS格式的代码 Excel to JSON javascript代码？

I am able to read Excel file via FileReader but it outputs text as well as weird characters with it. I need to read xls file row-wise, read data in every column and convert it to JSON.

Does anyone know how to read xls file row by row.

Any help would be highly appreciated.

解决方案

Below Function converts the Excel sheet (XLSX format) data to JSON. you can add promise to the function.

<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/xlsx.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.8.0/jszip.js"></script>
<script>
var ExcelToJSON = function() {

  this.parseExcel = function(file) {
    var reader = new FileReader();

    reader.onload = function(e) {
      var data = e.target.result();
      var workbook = XLSX.read(data, {
        type: 'binary'
      });

      workbook.SheetNames.forEach(function(sheetName) {
        // Here is your object
        var XL_row_object = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);
        var json_object = JSON.stringify(XL_row_object);
        console.log(json_object);

      })

    };

    reader.onerror = function(ex) {
      console.log(ex);
    };

    reader.readAsBinaryString(file);
  };
};
</script>

Below post has the code for XLS format Excel to JSON javascript code?

这篇关于如何在Javascript / HTML5中解析Excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！