# hlt-export-excel

> json export excel

Latest version **1.0.2** (published 2018-09-25) · Apache-2.0 license · 0 weekly downloads

## Install

```sh
npm install hlt-export-excel
pnpm add hlt-export-excel
yarn add hlt-export-excel
bun add hlt-export-excel
```

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 1.0.2 |
| Published | 2018-09-25 |
| First published | 2018-09-25 |
| Weekly downloads | 0 |
| License | Apache-2.0 |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 4 |
| Unpacked size | 623.1 KB |
| Known vulnerabilities | 0 (+5 in 1 direct dependencies) |
| Install scripts | no |
| GitHub stars | 0 |
| Author | hltfe |
| Maintainers | hltfe |
| Keywords | json export, excel, json export excel |

## Links

- npm: https://www.npmjs.com/package/hlt-export-excel
- Repository: https://github.com/hltfe/hlt-export-excel
- Homepage: https://github.com/hltfe/hlt-export-excel#readme
- Issues: https://github.com/hltfe/hlt-export-excel/issues
- npm.io page: https://npm.io/package/hlt-export-excel

## Dependencies (4)

- [xlsx](https://npm.io/package/xlsx.md) ^0.11.17
- [blob.js](https://npm.io/package/blob.js.md) ^1.0.1
- [file-saver](https://npm.io/package/file-saver.md) ^1.3.3
- [script-loader](https://npm.io/package/script-loader.md) 0.7.2

## Alternatives

- [@mapbox/jsonlint-lines-primitives](https://npm.io/package/@mapbox/jsonlint-lines-primitives.md) — 5.3M weekly downloads
- [reftools](https://npm.io/package/reftools.md) — 3.5M weekly downloads
- [@hey-api/openapi-ts](https://npm.io/package/@hey-api/openapi-ts.md) — 3.5M weekly downloads
- [@mapbox/geojson-rewind](https://npm.io/package/@mapbox/geojson-rewind.md) — 2.4M weekly downloads
- [turbo-stream](https://npm.io/package/turbo-stream.md) — 1.7M weekly downloads

## Recent versions

- 1.0.2 (latest) — 2018-09-25
- 1.0.1 — 2018-09-25
- 1.0.0 — 2018-09-25

## README

# hlt-export-excel

> 纯 js 导出 excel

## 下载

```
npm install hlt-export-excel

or

yarn add hlt-export-excel

```

## 文档

### 用法

```
    const ExportJsonExcel = require('hlt-export-excel')

    var option={};

    option.fileName = 'excel'
    option.datas=[
      {
        sheetData:[{one:'一行一列',two:'一行二列'},{one:'二行一列',two:'二行二列'}],
        sheetName:'sheet',
        sheetFilter:['two','one'],
        sheetHeader:['第一列','第二列'],
        columnWidths: [20, 20]
      },
      {
        sheetData:[{one:'一行一列',two:'一行二列'},{one:'二行一列',two:'二行二列'}]
      }
    ];

    var toExcel = new ExportJsonExcel(option); //new
    toExcel.saveExcel(); //保存
```

### option

1.datas 数据

```
   /*多个sheet*/
   /*每个sheet为一个object */
   [{
   sheetData:[], // 数据
   sheetName:'', // sheet名字
   sheetFilter:[], //列过滤
   sheetHeader:[] // 第一行
   columnWidths: [] //列宽 需与列顺序对应
   }]

```

2.fileName 下载文件名(默认：download)

#### sheet option
1.sheetName sheet 名字(可有可无)(默认 sheet1)
2.sheetHeader 标题（excel 第一行数据）

```
    sheetHeader: ["第一列", "第二列"];

```

3.columnWidths 列宽 非必须

```
    columnWidths = [20, ""];

```
4.sheetData 数据源(必须)

```
    <!--两种形式-->
    <!--第一种 object-->
    [{one:'一行一列',two:'一行二列'},{one:'二行一列',two:'二行二列'}]
    <!--第二种 arrary-->
    [['一行一列','一行二列'],['二行一列','二行二列']]

```

5.sheetFilter 列过滤(只有在 data 为 object 下起作用)(可有可无)

```
    sheetFilter = ["two", "one"];

```

---
_Source: https://npm.io/package/hlt-export-excel · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._