react exceljs

"exceljs": "^4.2.0",

npm install exceljs

import {Workbook} from 'exceljs';

const workbook = new Workbook;

const sheet = workbook.addWorksheet('Sheet1', {properties:{defaultRowHeight:25}});
        sheet.pageSetup.horizontalCentered = true;
        sheet.pageSetup.verticalCentered = true;
        sheet.columns = [
            {header:'title1',key:'title1',width: 25,style:{alignment:{vertical:'middle',horizontal:'center'}}},
            {header:'title2',key:'title2',width: 25,style:{alignment:{vertical:'middle',horizontal:'center'}}},
            {header:'title3',key:'title3',width: 30,style:{alignment:{vertical:'middle',horizontal:'center'}}},
        ];

sheet.addRow({title1: '111',
                                title2: '222',
                                title3: '333',
                            });

sheet.addRow({title1: '444',
                                title2: '555',
                                title3: '666',
                            });

sheet.mergeCells(1,1,2,2);

workbook.xlsx.writeBuffer().then((buffer) => {
                writeFile('Capability.xlsx', buffer);
            });

const writeFile = (fileName, content) => {
            let a = document.createElement("a");
            let blob = new Blob([content], { type: "text/plain" });
            a.download = fileName;
            a.href = URL.createObjectURL(blob);
            a.click();
        };

 

ref:https://github.com/exceljs/exceljs/blob/master/README_zh.md