h5页面如何预览excel文件_如何在excel／HTML5中解析excel文件

Kunal Vyasducktyped提出了一个问题：How to parse Excel file in Javascript/HTML5，或许与您遇到的问题类似。

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

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);

};

};

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

希望本文对你有帮助，欢迎支持JavaScript中文网