Exceljs Example Working in Browser

exceljs example

Test Online exceljs.js

Usage:

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

Related Topics