Exceljs 与 Sheetjs(xlsx.js)、 xlsx-populate.js 解析xlsx表格的性能对比、耗时对比

xlsx.js示例

快速试用 SheetJS xlsx.js

使用教程：

// <input type="file" onchange="parseExcelFile1(this)">
function parseExcelFile1(inputElement) {
  var files = inputElement.files || [];
  if (!files.length) return;
  var file = files[0];

  console.time();
  var reader = new FileReader();
  reader.onloadend = function(event) {
    var arrayBuffer = reader.result;
    // debugger

    var options = { type: 'array' };
    var workbook = XLSX.read(arrayBuffer, options);
    console.timeEnd();

    var sheetName = workbook.SheetNames
    var sheet = workbook.Sheets[sheetName]
    result1.innerHTML = XLSX.utils.sheet_to_html(sheet)
  };
  reader.readAsArrayBuffer(file);
}

相关主题

exceljs示例

快速试用 exceljs.js

使用教程：

// <input type="file" onchange="parseExcelFile2(this)">
function parseExcelFile2(inputElement) {
  var files = inputElement.files || [];
  if (!files.length) return;
  var file = files[0];

  console.time();
  var reader = new FileReader();
  reader.onloadend = function(event) {
    var arrayBuffer = reader.result;
    // var buffer = Buffer.from(arrayBuffer)
    // debugger

    var workbook = new ExcelJS.Workbook();
    // workbook.xlsx.read(buffer)
    workbook.xlsx.load(arrayBuffer).then(function(workbook) {
      console.timeEnd();
      var result = ''
      workbook.worksheets.forEach(function (sheet) {
        sheet.eachRow(function (row, rowNumber) {
          result += row.values + ' | \n'
        })
      })
      result2.innerHTML = result
    });
  };
  reader.readAsArrayBuffer(file);
}

相关主题

xlsx-populate.js示例

快速试用 xlsx-populate.js

使用教程：

// <input type="file" onchange="parseExcelFile3(this)">
function parseExcelFile3(inputElement) {
  var files = inputElement.files || [];
  if (!files.length) return;
  var file = files[0];

  console.time();
  XlsxPopulate.fromDataAsync(file).then(function(workbook) {
    console.timeEnd();
    // debugger
    var sheet = workbook.sheet(0)
    var rows = sheet._rows
    var result = ''
    rows.forEach(function (row) {
      row._cells.forEach(function (cell) {
        result += cell.value() || ''
      })
      result += ' | \n'
    })

    result3.innerHTML = result
  });
}

相关主题