Convert excel sheet to JSON data with Node Js using xlsx lib

excel2Json.js

const xlsx = require('xlsx')

function excelToJson() {
    //read the whole sheet
    const sheet = xlsx.readFile('/home/ravi/Desktop/message.xlsx')
    //depending on the sheet you want to convert, in my case I wanted the to convert
    //first sheet only
    const first_sheet = sheet.SheetNames[0]
    const sheet1 = sheet.Sheets[first_sheet]
    //returns array of object mapped to key pair values dynamically
    return xlsx.utils.sheet_to_json(sheet1)
}

data = excelToJson()
console.log(data)