npm install export-xlsx- support formula
- hierarchy structure
- multi-headers
$ npm i -S export-xlsx
``
import { alignment, defaultDataType } from 'export-xlsx';
// Export settings
export const SETTINGS_FOR_EXPORT = {
// Table settings
fileName: 'example',
workSheets: [
{
sheetName: 'example',
startingRowNumber: 2,
gapBetweenTwoTables: 2,
tableSettings: {
table1: {
tableTitle: "Score",
headerGroups: [
{
name: '',
key: 'void',
groupKey: 'directions',
},
{
name: 'Science',
key: 'science',
groupKey: 'directions',
},
{
name: 'Directions',
key: 'directions',
},
],
headerDefinition: [
{
name: '#',
key: 'number',
},
{
name: 'Name',
key: 'name',
},
{
name: 'SUM',
key: 'sum',
groupKey: 'void',
rowFormula: '{math}+{physics}+{chemistry}+{informatics}+{literature}+{foreignLang}',
},
{
name: 'Mathematics',
key: 'math',
groupKey: 'science',
},
{
name: 'Physics',
key: 'physics',
groupKey: 'science',
},
{
name: 'Chemistry',
key: 'chemistry',
groupKey: 'science',
},
{
name: 'Informatics',
key: 'informatics',
groupKey: 'science',
},
{
name: 'Literature',
key: 'literature',
groupKey: 'science',
},
{
name: 'Foreign lang.',
key: 'foreignLang',
groupKey: 'science',
},
{
name: 'AVG',
key: 'avg',
groupKey: 'void',
rowFormula: '{sum}/6',
}
],
}
}
},
],
};
`
`
import ExcelExport from 'export-xlsx';
import { SETTINGS_FOR_EXPORT } from './setting';
const data = {
table1: [
{
number: 1,
name: 'Jack',
sum: '',
math: 1,
physics: 2,
chemistry: 2,
informatics: 1,
literature: 2,
foreignLang: 1,
avg: '',
},
{
number: 2,
name: 'Peter',
sum: '',
math: 2,
physics: 2,
chemistry: 1,
informatics: 2,
literature: 2,
foreignLang: 1,
avg: '',
},
]
};
const excelExport = new ExcelExport();
excelExport.downloadExcel(SETTINGS_FOR_EXPORT, data);
`
If you have any questions, please contact me root@laravue.org`