Read internal excel file using React

Question

I have an excel file stored in src folder. I want to use react to read the excel file directly instead of uploading a file using input field and show the object array to the console, does anyone know how to do it? Any reference link about that? I saw a lot about uploading an excel file and output the data, but I don't want to upload the file. I want to import the file directly or fetch data from the file. Let me know if you know how to do in react. Thanks.

Aditya · Accepted Answer · 2021-11-03 06:42:55Z

1

You could use FileReader API. Here's a link to similar question. You could parse/read the excel file using this package.

A little suggestion, would be to use .csv or .json files instead of .xlsx files, if you are only dealing in data.

answered Nov 3, 2021 at 6:42

Aditya

1271 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

manimk · Accepted Answer · 2023-01-07 11:55:54Z

  fetch(excelFile).then((res) => res.arrayBuffer())
       .then((ab) => {
           const wb        = XLSX.read(ab, { type: "array" });
           const sheetname = wb.SheetNames[0]
           const ws        = wb.Sheets[sheetname]
           const json      = XLSX.utils.sheet_to_json(ws,{header: 1,defval:''})
           console.log(json)

Here excelFile is file location, you may include your excel file location, Then json contain excel data.

Thanks.

Collectives™ on Stack Overflow

Read internal excel file using React

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related