How to import/export Excel Sheet with React?

1

Any idea how to import multiple spreadsheets in react?

Currently im using react-excel-renderer for this but its to the following functionality:

  1. I can only get one spread sheet.
  2. If there are more sheets in the spreadsheet then it will only read the first one.

What i want:
I want to read multiple spreadsheets.

The code which im using currently is

import React, { Component } from "react";
import { ExcelRenderer, OutTable } from "react-excel-renderer";

class Dashboard2 extends Component {
  constructor(props) {
    super(props);
    this.state = {
      rows: [],
      cols: []
    };
  }
//  WORKING CODE ---------------------
  changeHandler(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
        });
        console.log(this.state);
      }
    });
  }
  //  WORKING CODE ---------------------


  render() {
    return (
      <div>
        <h1>Upload File</h1>
        <input
          className="btn"
          type="file"
          onChange={this.changeHandler.bind(this)}
          style={{ padding: "10px" }}
        />
        <OutTable
          data={this.state.rows}
          columns={this.state.cols}
          tableClassName="ExcelTable2007"
          tableHeaderRowClass="heading"
        />
      </div>
    );
  }
}

export default Dashboard2;
2

Do you mean merging multiple spreadsheets into one <OutTable> or rendering many <OutTable>'s, one per each spreadsheet?

3

No, i mean two things.
First: A single xlsx file but it contains multiple spreadsheets.
SECOND: Multiple xlsx files.

I want to first read these files and then store it. AND i want to show it also basically render on the DOM.
i hope im clear now.

4

@RohanKumarr Do you fixed the Multiple SpeardSheet from react-excel-renderer ? Am also facing the same issues.Please let me know.