export-html-table-to-excel
v3.0.2
Published
Small react component for converting and downloading HTML table to Excel file
Downloads
4
Maintainers
Readme
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;