I'm new to react and only have an entry level understanding of coding but need to use it for a project.
I'm trying to display data from a local csv file in a simple HTML table that can then be searched by a user on the page. So far I've only been able to find tutorials that require users to upload their own CSV first but I just need to have the data on the screen.
I appreciate that this is probably a really simple question but its all new to me and I just can't seem to find a solution that works.
This code is from one of the tutorials I've followed and returns the result I need but only when the user uploads the csv first.
import React, {useState, useCallback} from 'react'
import {useDropzone} from 'react-dropzone'
import Papa from 'papaparse';
import './App.css';
export default function MyDropzone () {
const onDrop = useCallback(acceptedFiles => {
if (acceptedFiles.length) {
parseFile(acceptedFiles[0]);
}
}, []);
const {getRootProps, getInputProps, isDragActive, isDragAccept, isDragReject} = useDropzone({onDrop, accept: 'text/csv'})
const [parsedCsvData, setParsedCsvData] = useState([]);
const parseFile = file => {
Papa.parse(file, {
header: true,
complete: results => {
setParsedCsvData(results.data)
},
});
};
return (
<div className="Archive">
<div
{...getRootProps({
className: `dropzone
${isDragAccept && 'dropzoneAccept'}
${isDragReject && 'dropzoneReject'}`,
})}
>
<input {...getInputProps()} />
{isDragActive ? (
<p>Drop the files here ...</p>
) : (
<p>Drag 'n' drop some files here, or click to select files</p>
)}
</div>
<table className="ArchiveTable">
<thead>
<tr>
<th>Kanji</th>
<th>Reading</th>
<th>English</th>
</tr>
</thead>
<tbody>
{parsedCsvData &&
parsedCsvData.map((parsedData, index) => (
<tr key={index}>
<td>{parsedData.Name}</td>
<td>{parsedData.Address}</td>
<td>{parsedData.Postcode}</td>
<td>{parsedData.Issue}</td>
<td>{parsedData.Date}</td>
<td>{parsedData.Score}</td>
</tr>
))}
</tbody>
</table>
</div>
);
}
Try this:
change the url inside fetch
to the location to your csv file in this line const response = await fetch("/data/nodes.csv");
.
import React, { useState, useEffect } from "react";
import "./App.css";
import Papa from 'papaparse';
export default function MyDropzone() {
const [parsedCsvData, setParsedCsvData] = useState([]);
useEffect(() => {
async function getData() {
const response = await fetch("/data/nodes.csv");
const reader = response.body.getReader();
const result = await reader.read(); // raw array
const decoder = new TextDecoder("utf-8");
const csv = decoder.decode(result.value); // the csv text
const results = Papa.parse(csv, { header: true }); // object with { data, errors, meta }
const rows = results.data; // array of objects
setParsedCsvData(rows);
}
getData();
}, []);
return (
<div className="Archive">
<table className="ArchiveTable">
<thead>
<tr>
<th>Kanji</th>
<th>Reading</th>
<th>English</th>
</tr>
</thead>
<tbody>
{parsedCsvData &&
parsedCsvData.map((parsedData, index) => (
<tr key={index}>
<td>{parsedData.Name}</td>
<td>{parsedData.Address}</td>
<td>{parsedData.Postcode}</td>
<td>{parsedData.Issue}</td>
<td>{parsedData.Date}</td>
<td>{parsedData.Score}</td>
</tr>
))}
</tbody>
</table>
</div>
);
}