React implements import and export of Excel files

import { Button,Table,Upload } from 'antd';

<Upload {...props} fileList={state.fileList}>
    <Button type="primary" >Excel Import</Button>
</Upload>

<Button type="primary" onClick={handleExport}>Excel export</Button>

// workbook understanding:
{
    SheetNames: ['sheet1', 'sheet2'],
    Sheets:
        // worksheet
        'sheet1': {
            // cell
            'A1': { ... },
            // cell
            'A2': { ... },
            ...
        },
        // worksheet
        'sheet2': {
            // cell
            'A1': { ... },
            // cell
            'A2': { ... },
            ...
        }
    }
}

const f = file;
const reader = new FileReader();
reader.onload = function (e) {
    try{
        const datas = e.target.result;
        const workbook = XLSX.read(datas, {type: "binary",}); //parse datas
        const first_worksheet = workbook.Sheets[workbook.SheetNames[0]]; //It is the first sheet in the workbook
        const jsonArr = XLSX.utils.sheet_to_json(first_worksheet, {header: 1,defval:''}); //Convert the workbook object to a JSON object array handleImpotedJson(jsonArr) //Array processing message.success('Excel upload parsing successful!')
    }catch(e){
      message.error('Incorrect file type! Or file parsing error')
    } 
};
reader.readAsBinaryString(f);

const downloadExcel = () => {
    const json = handleExportedJson(data)
    const sheet = XLSX.utils.json_to_sheet(json);
    openDownloadDialog(sheet2blob(sheet,"Sheet1"), "Download file.xls")
}
const handleExportedJson = (array) =>{...} // Process Json data const openDownloadDialog = (url, saveName) =>{...} // Open download const sheet2blob = (sheet, sheetName) =>{...} // Convert to blob type

// Export file directly let dataTable = []; //Data content in excel file let option = {}; //option represents excel file dataTable = data; //Data source option.fileName = "Download file"; //Excel file name console.log("data===",dataTable)
option.datas = [
    {
        sheetData: dataTable, //data source in excel filesheetName: 'Sheet1', //sheet page name in excel filesheetFilter: ['id', 'name', 'belong', 'step','tag'], //column data to be displayed in excel filesheetHeader: ['project id', 'project name', 'company', 'project stage','project tag'], //header name of each column in excel file}
]
let toExcel = new ExportJsonExcel(option); //Generate excel file toExcel.saveExcel(); //Download excel file

/*Multiple sheets*/
/*Each sheet is an object */
[{
    sheetData:[], // datasheetName:'', // (optional) sheet name, default is sheet1
    sheetFilter:[], // (optional) column filter (only works when data is object)
    sheetHeader:[] // First row, title columnWidths: [] // (optional) column width, must correspond to the column order}]