一、結果展示

主要功能：可以根據(jù)前端傳遞的參數(shù)，導出指定列、指定行

1.1 案例一

1. 前端頁面
   
2. 傳遞參數(shù)

{"excelName": "導出用戶信息1725738666946","sheetName": "導出用戶信息","fieldList": [{"fieldName": "userId","fieldDesc": "用戶id"},{"fieldName": "age","fieldDesc": "年齡"},{"fieldName": "address","fieldDesc": "地址"}]
}

3. 導出的文件
   

1.2 案例二

1. 前端頁面
   

2. 傳遞參數(shù)

{"excelName": "導出用戶信息1725739080367","sheetName": "導出用戶信息","fieldList": [{"fieldName": "userId","fieldDesc": "用戶id"},{"fieldName": "address","fieldDesc": "地址"},{"fieldName": "age","fieldDesc": "年齡"},{"fieldName": "userName","fieldDesc": "用戶名"}],"userIdList": ["1","3","5","8","9"]
}

3. 導出結果
   

二、代碼實現(xiàn)

工具類代碼結構

2.1 入?yún)?、出?/h4>

UserExportRequest

public class UserExportRequest extends ExcelExportRequest {/*** 要導出的用戶id列表，不傳，則導出所有用戶記錄*/private List<Integer> userIdList;public List<Integer> getUserIdList() {...}public void setUserIdList(List<Integer> userIdList) {...}
}---繼承自通用的ExcelExportRequest類---
public class ExcelExportRequest {/*** excel名稱*/private String excelName;/*** sheet的名稱*/private String sheetName;/*** 導出字段有序列表*/private List<ExcelExportField> fieldList;public String getSheetName() {...}public void setSheetName(String sheetName) {...}public String getExcelName() {...}public void setExcelName(String excelName) {...}public List<ExcelExportField> getFieldList() {...}public void setFieldList(List<ExcelExportField> fieldList) {...}
}

ExcelExportResponse

public class ExcelExportResponse {//導出的excel文件名稱private String excelName;// sheet列表數(shù)據(jù)private List<ExcelSheet> sheetList;public String getExcelName() {...}public void setExcelName(String excelName) {...}public List<ExcelSheet> getSheetList() {...}public void setSheetList(List<ExcelSheet> sheetList) {...}
}

2.2 生成ExcelExportResponse的邏輯

2.3 aop通知

2.4 下載Excel