React json to excel

![npm version]

Install

``
npm install react-json-to-excel --save
`

Peer modules

`
npm install file-saver xlsx --save
`

`
npm install react-json-to-excel --save
`

Using Button Component

`js
import { JsonToExcel } from "react-json-to-excel";

class SmapleComponent extends Component {
render() {
return (
title="Download as Excel"
data={[{ test: "test" }]}
fileName="sample-file"
btnClassName="custom-classname"
/>
);
}
}
`

Usage

`js
import { JsonToExcel } from "react-json-to-excel";
const samplejson1 = [
{ label: "C" },
{ label: "Java" },
{ label: "Go" },
{ label: "Javascript" },
{ label: "HTML" },
{ label: "CSS" },
{ label: "REACT" },
{ label: "JQUERY" }
];

const samplejson2 = [
{ name: "name01" , age:"20",sex:"M" },
{ name: "name02" , age:"22",sex:"F" }
{ name: "name03" , age:"20",sex:"M" }
];

class SmapleComponent2 extends Component {
render() {
return (
title="Download as Excel"
data={samplejson}
fileName="sample-file"
/>
title="Download as Excel"
data={samplejson2}
fileName="sample-file"
/>
);
}
}
`

Using exportToExcel Method

`
import { exportToExcel } from 'react-json-to-excel';

const samplejson2 = [
{ name: 'name01', age: '20', sex: 'M' },
{ name: 'name02', age: '22', sex: 'F' },
{ name: 'name03', age: '20', sex: 'M' },
];

class SmapleComponent2 extends Component {

render() {
return (
exportToExcel(samplejson2, 'downloadfilename')}>
Download using method

);
}
}

`

Using exportToExcel Method For Multiple sheets

`
[{
sheetName:"sheet1",
details:[{ name: 'name01', age: '20', sex: 'M' },
{ name: 'name02', age: '22', sex: 'F' },
{ name: 'name03', age: '20', sex: 'M' }]
},{
sheetName:"sheet2",
details:[{ name: 'name01', age: '20', sex: 'M' },
{ name: 'name02', age: '22', sex: 'F' },
{ name: 'name03', age: '20', sex: 'M' }]
}]
`

`
import { exportToExcel } from 'react-json-to-excel';

const samplejson2 = [
{ name: 'name01', age: '20', sex: 'M' },
{ name: 'name02', age: '22', sex: 'F' },
{ name: 'name03', age: '20', sex: 'M' },
];

class SmapleComponent2 extends Component {

render() {
return (
exportToExcel(samplejson2, 'downloadfilename', true )}>
Download using method

);
}
}

``

Example

!Screenshot
!Screenshot

PROPTYPES

| Prop | Type | Info |
| ------------ | ------ | -------------------------------------------------------- |
| title | String | name of the button |
| btnClassName | String | class name added to the the button for css customization |
| data | Array | array of objects |
| fileName | String | download file name |
| btnColor | String | color of button defatlt to #4CAF50 |

react-json-to-excel