An downloadable excel workbook react component
npm install react-excel-workbookjsx
import Workbook from 'react-excel-workbook'
const data1 = [
{
foo: '123',
bar: '456',
baz: '789'
},
{
foo: 'abc',
bar: 'dfg',
baz: 'hij'
},
{
foo: 'aaa',
bar: 'bbb',
baz: 'ccc'
}
]
const data2 = [
{
aaa: 1,
bbb: 2,
ccc: 3
},
{
aaa: 4,
bbb: 5,
ccc: 6
}
]
const example = (
Try me!}>
row.aaa * 2}/>
Math.pow(row.ccc, 3)}/>
)
render(example, document.getElementById('app'))
`
!Example
!Excel
Workbooks can have multiple sheets. Sheets can use the same or different data sets(an array of objects).
Sheets have columns. Columns define a column label and value. Values can either be a string(the property name) or a function
that takes the current object and returns a value.
Dependencies
This package uses file-saver and xlsx packages. I am only familiar with webpack and in order for everything to work with webpack you must use the json-loader and have this defined in your webpack config.
`js
node: {fs: 'empty'},
externals: [
{'./cptable': 'var cptable'},
{'./jszip': 'jszip'}
]
`
See the example` directory for a working example.