JSON same column getting last value (Excel to html table)

Question

So I have three same name column in excel. I want to get all of it and display in HTML table using push. the problem is. i only get the last item. I'm not the great in English so i hope u guys all understand.

const bulkFileENU = document.getElementById('bulkFileENU');

var ExcelToJSON = function () {
    this.parseExcel = function (file) {
        var reader = new FileReader();

        reader.onload = function (e) {
            var data = e.target.result;
            var workbook = XLSX.read(data, {
                type: 'binary'

            });
            workbook.SheetNames.forEach(function (sheetName) {
                var XL_row_object = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[sheetName]);
                var json_object = JSON.stringify(XL_row_object);
                var asdf = (JSON.parse(json_object));
                DisplayObjectENU(asdf)
            })
        };

        reader.onerror = function (ex) {
            console.log(ex);
        };

        reader.readAsBinaryString(file);
    };
};

bulkFileENU.addEventListener('change', function (evt) {
    var files = evt.target.files;
    var xl2json = new ExcelToJSON();
    xl2json.parseExcel(files[0]);
});

function DisplayObjectENU(excelData) {
    var tableExcel = document.getElementById('excelBulkENUTable');

    excelData.forEach((x) => {
        tableExcel.innerHTML +=
                 `` +
                 `${x.QuesName}` +
                 `${x.CorrectAnswer}` +
                  `${x.WrongAnswer}` +
                 `${x.QuesPoints}` +
                 ``
    });
}

table,tbody,td{
  border: 1px solid black;
}







    


  
    
      
        

          Questions
          Choices
          Answer
          Points

Please view this. this the This is Excel File

Expected output

JSON same column getting last value (Excel to html table)

0 Answers