I am trying to set columns name using the Xlsx npm package, after that, I want to map the excel file to get the value of the cells, I want to do something like the below code. is it something similar possible with the xlsx or any package, I have tried the convert-excel-to-json npm, the problem is with this package is sometimes the cell will be empty so I want to get the empty cell too, on this package it is skipping the empty cell.
// Mapping columns to keys
columnToKey: {
A: "roll",
B: "name",
C: "English",
D: "Math", }
const mapExcel = excelData.sheetName.map((student) => {
const {
roll,
name,
English, Math } = student }