| | |
|---|
| | | public R downloadSettlementTotal(@RequestBody ExportUidDto uid,HttpServletResponse response) |
|---|
| | | { |
|---|
| | | SettlementTotalVO data = chargingOrderClient.settlementTotalR(uid.getTime()).getData(); |
|---|
| | | |
|---|
| | | |
|---|
| | | try { |
|---|
| | | response.setCharacterEncoding(Constants.UTF8); |
|---|
| | | response.setContentType("application/vnd.ms-excel"); |
|---|
| | |
|---|
| | | WriteSheet writeSheet = EasyExcel.writerSheet().build(); |
|---|
| | | FillConfig fillConfig = FillConfig.builder().direction(WriteDirectionEnum.VERTICAL).build(); |
|---|
| | | excelWriter.fill(new FillWrapper("data1", data.getList1()), fillConfig, writeSheet); |
|---|
| | | // excelWriter.fill(new FillWrapper("data2", data.getList2()), fillConfig, writeSheet); |
|---|
| | | excelWriter.fill(new FillWrapper("data2", data.getList2()), fillConfig, writeSheet); |
|---|
| | | excelWriter.finish(); |
|---|
| | | } catch (Exception e) { |
|---|
| | | return R.fail("excel导出失败！"); |
|---|
| | |
|---|
| | | response.setContentType("application/vnd.ms-excel"); |
|---|
| | | response.setHeader("Access-Control-Expose-Headers", "Content-disposition"); |
|---|
| | | response.setHeader("Content-Disposition", "attachment;filename=" + |
|---|
| | | URLEncoder.encode("月账单-"+data.getCategory()+data.getBillWeek()+data.getSiteName(), CharEncoding.UTF_8) + ".xlsx"); |
|---|
| | | // URLEncoder.encode("月账单-"+data.getCategory()+data.getBillWeek()+data.getSiteName(), CharEncoding.UTF_8) + ".xlsx"); |
|---|
| | | URLEncoder.encode("月账单", CharEncoding.UTF_8) + ".xlsx"); |
|---|
| | | } catch (UnsupportedEncodingException e) { |
|---|
| | | return R.fail("excel导出失败！"); |
|---|
| | | } |
|---|
