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;