export-html-table-to-excel

ReactHTMLTableToExcel

Provides a client side generation of Excel (.xls) file from HTML table element.

---

No additional dependencies

---

Installation

npm install --save export-html-table-to-excel

Features

• Download HTML table as Excel file in .xls format
• No server side code
• Set desired .xls filename and sheet
• Set desired class name and id for styling
• Supported IE 11

Options

A list of available properties can be found below. These must be passed to the containing ReactHTMLTableToExcel component.

Property	Type	Description
table	string	ID attribute of HTML table element.
filename	string	Name of Excel file.
sheet	string	Name of Excel sheet.
id	string	ID attribute of button element.
className	string	Class attribute of button element.
buttonText	string	Button text.
children	element	Child elements to render instead of the button text.

Example

import React, { Component } from "react";
import ReactHTMLTableToExcel from "export-html-table-to-excel";

class Test extends Component {
  constructor(props) {
    super(props);
  }

  render() {
    return (
      <div>
        <ReactHTMLTableToExcel
          id="test-table-xls-button"
          className="download-table-xls-button"
          table="table-to-xls"
          filename="tablexls"
          sheet="tablexls"
          buttonText="Download as XLS"
        />
        <table id="table-to-xls">
          <tr>
            <th>Firstname</th>
            <th>Lastname</th>
            <th>Age</th>
          </tr>
          <tr>
            <td>Jill</td>
            <td>Smith</td>
            <td>50</td>
          </tr>
          <tr>
            <td>Eve</td>
            <td>Jackson</td>
            <td>94</td>
          </tr>
        </table>
      </div>
    );
  }
}

export default Test;