get column names from excel using exceljs / xlsx in nodejs

Question

I am using exceljs to fetch data from excel. I have written the below code. I am able to get the values inside the rows. But, I am not understanding how to get the column names.

let workbook = new ExcelJs.Workbook();
  workbook.xlsx.load(edata).then(async function(wb){
    wb.eachSheet((sheet, id) => {
      sheet.eachRow({ includeEmpty: false }, function(row, rowIndex) {
      console.log(row.values)
      })
    })
})

Please help me in fetching the column names. Thanks in advance!!

SelVazi · Accepted Answer · 2023-07-17 12:18:56Z

1

Try using XLSX.utils.sheet_to_json :

const [columns] = XLSX.utils.sheet_to_json(workbook.Sheets[YOUR_SHEET_NAME], { header: 1 });

edited Jul 17, 2023 at 12:18

SelVazi

16.2k2 gold badges20 silver badges35 bronze badges

answered Apr 11, 2022 at 11:11

Mauro Bagnoli

193 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

get column names from excel using exceljs / xlsx in nodejs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related