Provides a client side generation of Excel (.xls) file from HTML table element.
No additional dependencies
npm install --save react-html-table-to-excel
- 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
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. |
importReact,{Component}from'react';importReactHTMLTableToExcelfrom'react-html-table-to-excel';classTestextendsComponent{constructor(props){super(props);}render(){return(<div><ReactHTMLTableToExcelid="test-table-xls-button"className="download-table-xls-button"table="table-to-xls"filename="tablexls"sheet="tablexls"buttonText="Download as XLS"/><tableid="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>);}}exportdefaultTest