这里是导出一个excel文件,里面有两个sheet
分别是税赋预测表和发票汇总表
controller层
@requestMapping(value = "/exportExcel/taxForecast", method = Method.GET)
public Result<String> exportExcel(String uid, String accountCodeList, Date startDate, Date endDate, HttpServletResponse response) {
log.info("帐套查询参数{},开始时间{},结束时间{},uid:{}",, accountCodeList, startDate, endDate, uid);
try {
List<TaxForeDTO> taxFore = iTaxForeCast.getTaxFore(accountCodeList, uid, startDate, endDate);
getVO(taxFore);
stripTrailingZeros(taxFore);
List<TaxForeEO> taxForeEOList = new ArrayList<>();
List<InvoiceTaxForeEO> invoiceTaxForeEOS = new ArrayList<>();
taxFore.forEach(taxForeDTO -> {
InvoiceTaxForeEO invoiceTaxForeEO = new InvoiceTaxForeEO();
BeanCopyUtils.copy(taxForeDTO, invoiceTaxForeEO);
invoiceTaxForeEOS.add(invoiceTaxForeEO);
TaxForeEO taxForeEO = new TaxForeEO();
BeanCopyUtils.copy(taxForeDTO, taxForeEO);
taxForeEOList.add(taxForeEO);
});
Map<String, List<? extends BaseRowModel>> map = new HashMap<>();
map.put("税赋预测表", taxForeEOList);
map.put("发票汇总表", invoiceTaxForeEOS);
EasyExcelUtils.createExcelStreamMutilByEaysEx