Links

CSV

Import and Export from CSV file
Use the @rowsncolumns/toolkit package to read, write and download CSV files from SheetData object
@rowsncolumns/toolkit is dependent on @rowsncolumns/spreadsheet-state package, and expects sheet data in type SheetData format

Import from CSV

import { createRowDataFromCSVFile } from "@rowsncolumns/toolkit";
const App = () => {
const handleChange = async (e) => {
const file = e.target.files[0]
const rowData = await createRowDataFromCSVFile(file)
const newSheetId = uuid()
onChangSheetData(prev => {
return {
...prev,
[newSheetId]: rowData
}
})
}
return (
<div>
<input type="file" onChange={handleChange} />
</div>
)
}

Export to CSV

import { exportToCSV } from "@rowsncolumns/toolkit";
const App = () => {
const [ sheetData, onChangeSheetData] = useState<SheetData>()
return (
<div>
<button onClick={() => exportToCSV({ filename: 'csvfile', rowData: sheetData[1] }) }>Export to CSV</button>
<CanvasGrid />
</div>
)
}