前端导出excel两种方法

//导出
    const handleExport = () => {
        setExportLoading(true)
        const { isPackage, paymentDays } = form.getFieldsValue();
        fetch(`/orderdriverpc/api/report/exportExcel`, {
            method: 'POST',
            headers: {
                'Content-Type': 'application/json',
            },
            redirect: 'follow',
            body: JSON.stringify({
                packageId: taskId?.split('-')[0],
                orgId: gridInfo !== '' ? gridInfo : (cityInfo !== '' ? cityInfo : (areaInfo !== '' ? areaInfo : (provInfo !== '' ? provInfo : ''))),
                orgLevel: tabValue,
                isPackage: isPackage,
                provinceCode: currentUser?.provinceCode,
                paymentDays: paymentDays.format('YYYY-MM-DD'),
            }),
        })
            .then((res) => res.blob())
            .then((e) => {
                setExportLoading(false)
                let objectUrl = URL.createObjectURL(e);
                const a = document.createElement('a');
                a.style.display = 'none';
                a.download = paymentDays.format('YYYY-MM-DD') + '组织维度报表.xlsx';
                a.href = objectUrl;
                a.click();
            });
    };

---

导出为excel文件的方法
    const downloadFileToExcel = () => {
        let option = {}; //option代表的就是excel文件
        let dataTable = []; //excel文件中的数据内容
        let theadArr = []; //excel表头
        let theadArrDataIndex = []; //excel表头索引
        dataForDownLoad?.tHead &&
            dataForDownLoad.tHead.length > 0 &&
            dataForDownLoad?.tHead.map((item) => {
                theadArr.push(item.title);
                theadArrDataIndex.push(item.dataIndex);
            });
        dataForDownLoad?.tBody &&
            dataForDownLoad.tBody.length > 0 &&
            dataForDownLoad?.tBody.map((item, index) => {
                if (!item.key) {
                    item.key = index;
                }
                let obj = {};
                theadArr.map((i, x) => {
                    obj[i] = item[theadArrDataIndex[x]];
                });
                dataTable.push(obj); //设置excel中每列所获取的数据源
            });
        option.fileName = dataForDownLoad?.title; //excel文件名称
        option.datas = [
            {
                sheetData: dataTable, //excel文件中的数据源
                sheetName: dataForDownLoad?.title, //excel文件中sheet页名称
                sheetFilter: theadArr, //excel文件中需显示的列数据
                sheetHeader: theadArr, //excel文件中每列的表头名称
            },
        ];
        let toExcel = new ExportJsonExcel(option); //生成excel文件
        toExcel.saveExcel(); //下载excel文件
    };