# @betaquick/json2excel

> Convert JSON to excel Binary

Latest version **1.0.2** (published 2020-01-25) · MIT license · 0 weekly downloads

## Install

```sh
npm install @betaquick/json2excel
pnpm add @betaquick/json2excel
yarn add @betaquick/json2excel
bun add @betaquick/json2excel
```

## Health

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

Positive: has types; no vulnerabilities.

Warnings: low downloads; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 1.0.2 |
| Published | 2020-01-25 |
| First published | 2020-01-25 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | bundled |
| Module format | CommonJS |
| Node | >= 6.0.0 |
| Dependencies | 2 |
| Unpacked size | 943.5 KB |
| Known vulnerabilities | 0 (+5 in 1 direct dependencies) |
| Install scripts | no |
| GitHub stars | 0 |
| Author | BetaQuick LLC |
| Maintainers | favouroked, devgson, oneeyedsunday, radiumrasheed, walef |
| Keywords | json, excel, xlsx |

## Links

- npm: https://www.npmjs.com/package/@betaquick/json2excel
- Repository: https://github.com/betaquick/js2excel
- Homepage: https://github.com/betaquick/js2excel#readme
- Issues: https://github.com/betaquick/js2excel/issues
- npm.io page: https://npm.io/package/@betaquick/json2excel

## Dependencies (2)

- [xlsx](https://npm.io/package/xlsx.md) ^0.15.4
- [babel-preset-stage-2](https://npm.io/package/babel-preset-stage-2.md) ^6.24.1

## 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) — 2020-01-25

## README

![download](https://img.shields.io/npm/dt/js2excel.svg) ![npm-version](https://img.shields.io/npm/v/js2excel.svg) ![license](https://img.shields.io/npm/l/js2excel.svg) ![bower-license](https://img.shields.io/bower/l/js2excel.svg)

## js2excel
A simple module for excel and json converts each other.

## Installation

It is recommended to run webpack on node 6.x or higher.

Install the pkg with npm:

```
npm install js2excel --save
```

or yarn

```
yarn add js2excel
```

or bower

```
bower install js2excel
```

## Usage

### Convert json to excel
```
// es6
import json2ExcelBin from 'js2excel';

//CommonJS
let json2ExcelBin = require('js2excel');

// excel's data will be exports, which you probably get it from server.
let data = [
    {
        "userId": 1,
        "userPhoneNumber": 1888888888,
        "userAddress": 'xxxx',
        "date": '2013/09/10 09:10'  // string
    },
    {
        "userId": 2,
        "userPhoneNumber": 1888888888,
        "userAddress": 'xxxx',
        "date": new Date()
    },
    {
        "userId": 3,
        "userPhoneNumber": 1888888888,
        "userAddress": 'xxxx',
        "date": new Date()
    }
];

// this will be export a excel and the file's name is user-info-data.xlsx
// the default file's name is excel.xlsx
try {
    json2ExcelBin({
        data,
        name: 'user-info-data',
        formateDate: 'yyyy/mm/dd',
        // headers: ['S/N', 'Phone', 'Address', 'Date']
    });
} catch (e) {
    console.error('export error');
}

// for webpack 3: dynamic import
import(/* webpackChunkName: "js2excel" */ 'js2excel').then(({json2excel}) => {
    json2excel({
        data,
        name: 'test',
        formateDate: 'dd/mm/yyyy',
        // headers: ['S/N', 'Phone', 'Address', 'Date']
    });
}).catch((e) => {

});
```

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