# export-table-to-excel

**Repository Path**: chenc041/export-table-to-excel

## Basic Information

- **Project Name**: export-table-to-excel
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2018-12-26
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

## 一个将表格导出到excel的小工具

### 使用方法

```
npm i export-table-to-excel or yarn add export-table-to-excel

import ExportTableToExcel from 'ExportTableToExcel';

```

* 主要 api

  * fileName 导出文件名，默认卫为时间戳
  * data 表格数据，数据结构见下方使用方法
  * dom 节点，作为 children 传入
  * style 导出按钮样式, 格式, { dispaly: 'none' }


* 直接传递 table dom
```js
import React, { Component } from 'react';
import ExportTableToExcel from 'ExportTableToExcel';

export default class Demo extends Component {
  render() {
    return (
      <ExportTableToExcel>
        <div>
          <table border="1" align="center">
            <thead>
              <tr>
                <th>Firstname</th>
                <th>Lastname</th>
                <th>Email</th>
              </tr>
            </thead>
            <tbody>
              <tr>
                <td>John</td>
                <td>Doe</td>
                <td>john@example.com</td>
              </tr>
            </tbody>
          </table>
        </div>
      </ExportTableToExcel>
    );
  }
}

```

* 传递数据

```js
const mockData = {
  header: ['firstName', 'lastName', 'email'],
  body: [['jack', 'tom', 'google.com'], ['jack', 'tom', 'google.com']],
};

import React, { Component } from 'react';
import ExportTableToExcel from 'ExportTableToExcel';

export default class Demo extends Component {
  render() {
    return (
      <ExportTableToExcel data={mockData} />
    );
  }
}

```