JSFiddle - React, Tailwind, and code Playground
Spreadsheet Parser SheetJS Spreadsheet Parser Demo
by skibulk
HTML
<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.9.4/xlsx.full.min.js"></script>
<input type="file" id="fileSelect">
CSS
div {
border: 3px dashed lightgray;
padding: 40px;
margin: 10px;
text-align: center;
color: #BBB;
}
JavaScript
/* fixdata and rABS are defined in the drag and drop example */
function handleFile(e) {
var files = e.target.files;
var i,f;
for (i = 0; i != files.length; ++i) {
f = files[i];
var reader = new FileReader();
var name = f.name;
reader.onload = function(e) {
var data = e.target.result;
var workbook;
/* if binary string, read with type 'binary' */
workbook = XLSX.read(data, {type: 'binary'});
console.log(workbook);
// console.log(workbook.Sheets["06 12"]);
/* DO SOMETHING WITH workbook HERE */
};
reader.readAsBinaryString(f);
}
}
document.getElementById('fileSelect').addEventListener('change', handleFile, false);