| | |
|---|
| | | { |
|---|
| | | // 导入主表数据（Sheet1） |
|---|
| | | ExcelUtil<ReceivableFeeManagement> mainUtil = new ExcelUtil<ReceivableFeeManagement>(ReceivableFeeManagement.class); |
|---|
| | | List<ReceivableFeeManagement> receivableFeeList = mainUtil.importExcel("Sheet1", file.getInputStream(),10000); |
|---|
| | | List<ReceivableFeeManagement> receivableFeeList = mainUtil.importExcel("应收费用主表", file.getInputStream(),10000); |
|---|
| | | |
|---|
| | | // 导入明细表数据（Sheet2）并关联到主表 |
|---|
| | | ExcelUtil<ReceivableFeeDetail> detailUtil = new ExcelUtil<ReceivableFeeDetail>(ReceivableFeeDetail.class); |
|---|
| | | List<ReceivableFeeDetail> detailList = detailUtil.importExcel("Sheet2", file.getInputStream(),10000); |
|---|
| | | List<ReceivableFeeDetail> detailList = detailUtil.importExcel("应收费用明细", file.getInputStream(),10000); |
|---|
| | | |
|---|
| | | // 将明细数据关联到对应的主表记录 |
|---|
| | | if (detailList != null && !detailList.isEmpty()) { |
|---|
