New to Kendo UI for jQuery? Download free 30-day trial

Convert an XLSX File to JSON without Using a Spreadsheet Widget

Environment

Product Progress® Kendo UI® Spreadsheet for jQuery

Description

How can I convert an XLSX file to JSON without initializing a Spreadsheet widget?

Solution

Use a kendo.spreadsheet.Workbook object.

<div>
  1. Click to load an .xlsx file
  <input type="file" name="files" id="fileForUpload" accept=".xlsx" />
</div>
<br/>
<div>
  2. Click to print the file JSON on the console
  <input type="button" value="Click to read file" id="btn" />
</div>

<script>
  $('#btn').on('click', function() {
    var file = document.getElementById("fileForUpload").files[0];

    if (file) {
      var workbook = new kendo.spreadsheet.Workbook({});

      workbook.fromFile(file).then(function(){
        var jsonContent = workbook.toJSON();
        console.log(jsonContent);
      })
    }
  });
</script>

See Also

In this article