CSV
Import and Export from CSV file
Use the @rowsncolumns/toolkit
package to read, write and download CSV files from SheetData
object
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>
)
}
Last updated
Was this helpful?