Excel import/export toolkit

Reading Excel file from NodeJS

import { Workbook, getSheets, getCharts, processSheetData } from "@rowsncolumns/toolkit"


const workbook = new Workbook()

// Load the excel file to workbook
await workbook.load(file)

const [sheets, tables, dataValidations] = await getSheets(workbook)

// SheetData 

for await (const result of processSheetData(workbook,e.data.pageSize)) {
  // Process result
}

// Charts
const charts = await getCharts(workbook);

// Cleanup
workbook.dispose();