使用Sheetjs和FileReader.js将XLS转换为JSON

<script src="https://unpkg.com/xlsx/dist/xlsx.full.min.js"></script>
<script src="https://unpkg.com/filereader.js"></script>

<input type="file" id="xlsFileInput" accept=".xls" />

<button onclick="convertXlsToJson()">转换为JSON</button>

<pre id="jsonOutput"></pre>

function convertXlsToJson() {
  var fileInput = document.getElementById('xlsFileInput');
  var file = fileInput.files[0];
  
  var reader = new FileReader();
  reader.onload = function(e) {
    var data = new Uint8Array(e.target.result);
    var workbook = XLSX.read(data, { type: 'array' });
    var worksheet = workbook.Sheets[workbook.SheetNames[0]];
    var json = XLSX.utils.sheet_to_json(worksheet, { header: 1 });
    
    var jsonOutput = document.getElementById('jsonOutput');
    jsonOutput.textContent = JSON.stringify(json, null, 2);
  };
  reader.readAsArrayBuffer(file);
}