通过接口导出

268 阅读1分钟
            outExcel () {
                this.globaljs.analytics('在线查询_液位查询_导出表格', sessionStorage.memoryPhonenum);
                this.isLoading = true;
                this.axios({
                    method: 'post',
                    url: `/api-cang/api/report/query/exportLiquidInfoList`,
                    data: {
                        siteId: this.currentActiveHouse.siteid
                    },
                    responseType: 'blob'
                }).then(res => {
                    if (window.navigator.msSaveBlob) {
                        var downloadFileName = `液位查询-${moment().format("YYYYMMDDHHmmss")}.xls`;
                        try {
                            var blobObject = new Blob([res.data]);
                            window.navigator.msSaveBlob(blobObject, downloadFileName);
                            this.isLoading = false;
                        } catch (e) {
                            console.log(e);
                            this.isLoading = false;
                        }
                    } else {
                        var blob = new Blob([res.data], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8' });
                        var downloadElement = document.createElement('a');
                        var href = window.URL.createObjectURL(blob); // 创建下载的链接
                        downloadElement.href = href;
                        downloadElement.download = `液位查询-${moment().format("YYYYMMDDHHmmss")}.xls`; // 下载后文件名
                        document.body.appendChild(downloadElement);
                        downloadElement.click(); // 点击下载
                        document.body.removeChild(downloadElement); // 下载完成移除元素
                        window.URL.revokeObjectURL(href); // 释放掉blob对象
                    }
                }).catch(e => {
                    this.$message.error(e.message)
                }).finally(() => {
                    this.isLoading = false;
                })
            },