Importing and editing excel sheet in React Js

There's a library available for this ! Its called react-excel-renderer

import {ExcelRenderer, OutTable} from 'react-excel-renderer';

Provide the file object to the ExcelRenderer function in your event handler

fileHandler = (event) => {

let fileObj = event.target.files[0];

//just pass the fileObj as parameter

ExcelRenderer(fileObj, (err, resp) => {

if(err){

console.log(err);

}

else{

this.setState({

cols: resp.cols,

rows: resp.rows

});

}

});

}

Once JSON is obtained, provide it to the OutTable component

Demo : https://ashishd751.github.io/excel-renderer-demo/

1 Reply

Know the answer? Post it — somebody with the same question will find it here.