Excel to JSON

xlsx.vue

<template>
  <input ref="fileupload" type="file" @change="onFileChange" accept=".xlsx, .xls, .csv" />
</template>

<script>
/***
 * Spreadsheet data toolkit https://github.com/SheetJS/js-xlsx
 * npm i xlsx
 */
import XLSX from "xlsx";

export default {
  name: "ExcelJson",
  methods: {
    onFileChange(oEvent) {
      let oFile = oEvent.target.files[0];
      if (!oFile) return;

      let sFilename = oFile.name;

      let reader = new FileReader();
      let result = {};

      reader.onload = function(e) {
        let data = e.target.result;
        data = new Uint8Array(data);
        let workbook = XLSX.read(data, { type: "array" });
        console.log(workbook);
        let result = {};
        workbook.SheetNames.forEach(function(sheetName) {
          let roa = XLSX.utils.sheet_to_json(workbook.Sheets[sheetName], {
            raw: true
          });
          if (roa.length) result[sheetName] = roa;
        });
        // see the result, caution: it works after reader event is done.
        console.log("result", result);
      };
      reader.readAsArrayBuffer(oFile);
      this.$refs.fileupload.value = null;
    }
  }
};
</script>