Comment on page
Excel
Import and Export from XLSX files
Use the
@rowsncolumns/toolkit package to read, write and download Excel files from SheetData objectimport { createRowDataFromExcelFile } from "@rowsncolumns/toolkit";
const App = () => {
const handleChange = async (e) => {
const file = e.target.files[0]
const { sheets, sheetData, tables } = await createRowDataFromExcelFile(file)
onChange(sheets)
onChangSheetData(sheetData)
onChangeTables(tables)
// Call calculateNow to trigger a full-recalc if you are using
// useSpreadsheetState hook
}
return (
<div>
<input type="file" onChange={handleChange} />
</div>
)
}
Coming Soon!