I am currently creating a web application that allows a user to upload an excel file into a database but before the user uploads the file I would like to allow them to check the headers of the excel file if it matches the preset on the database.
The code below allows me to display everything on the excel file:
$('#inputfile').change(function(e){
var reader = new FileReader();
reader.readAsArrayBuffer(e.target.files[0]);
reader.onload = function(e) {
var data = new Uint8Array(reader.result);
var wb = XLSX.read(data,{type:'array'});
var htmlstr = XLSX.write(wb,{sheet:"Sheet1", type:'binary',bookType:'html'});
$('#printHere')[0].innerHTML += htmlstr;
}
});
I would like to only store the excel file’s header in an array and display it.
I’m new to Javascript so any help would be much appreciated.
You can do something like:
Here is the whole example:
SheetJS: Pass the worksheet and the function returns an array of column names:
Reference: Solution adopted from Github Issue
More Info: If you want to know more about the general structure, then please look at the official link