I have an Excel file. In Excel, I have multiple sheets and in a sheet, there are multiple tables.
I need to catch tables data in different arrays. I have use below package for node js.
const ExcelJS = require('exceljs');
const workbook = new ExcelJS.Workbook();
await workbook.xlsx.readFile('test.xlsx');
const sheet = workbook.getWorksheet('Global variables');
const table = sheet.getTable('Commodities_prices');
I have already found the list of all the tables in the single sheet but not able to find all the data of the particular table