So I'm trying to get all the headers from an excel (.xlsx) file using SheetJs. Here's my code:
import * as XLSX from "xlsx";
const readExcelHeaders=(file)=>{
const fileReader = new FileReader()
fileReader.readAsArrayBuffer(file)
fileReader.onload=(e)=>{
const bufferArray=e.target.result
const wb=XLSX.read(bufferArray,{type:'buffer'})
const wsname=wb.SheetNames[0]
const ws=wb.Sheets[wsname]
const data=XLSX.utils.sheet_to_json(ws)
}
}
But I keep getting the error `"XLSX.read is not a function". If anyone can help me figure out why I would really appreciate it.