CLICK HERE FOR XLSX HEADER IMAGE
I am struggling to retrieve the header and footer data from an xlsx file. I have only managed to access the information inside the workbook so far.
I attempted to extract the header/footer using the following method, but it did not work as expected:
import * as XLSX from 'xlsx';
const firstSheetName = ws.SheetNames[0];
const worksheet = ws.Sheets[firstSheetName];
const headerCells = XLSX.utils.sheet_to_json(worksheet, { header: 1 })[0];
console.log("headerCells :",headerCells);