Answers for "get excel file data to json"

get excel file data to json

//you must have xlsx
//npm install xlsx
let selectedFile;
console.log(window.XLSX);
document.getElementById('files').addEventListener("change", (event) => {
    selectedFile = event.target.files[0];
})

let data=[{
    "name":"placement",
    "data":"worksheet",
    "abc":"efg"
}]


document.getElementById('files').addEventListener("change", () => {
    XLSX.utils.json_to_sheet(data, 'Godplacement.xlsx');
    if(selectedFile){
        let fileReader = new FileReader();
        fileReader.readAsBinaryString(selectedFile);
        fileReader.onload = (event)=>{
         let data = event.target.result;
         let workbook = XLSX.read(data,{type:"binary"});
         console.log(workbook);
         workbook.SheetNames.forEach(sheet => {
              let rowObject = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheet]);
              console.log(rowObject);
              document.getElementById("jsondata").innerHTML = JSON.stringify(rowObject,undefined,4)
         });
        }
    }
});