java批量导入数据到excel

1.查询并返回结果list集合

private List tbTaxOrderList = null;

@RestController
@RequestMapping("/core/order")
public class TbTaxOrderController {public static final Logger LOGGER = Logger.getLogger("TbTaxOrderController");@Autowiredprivate ITbTaxOrderService tbTaxOrderService;@Autowiredprivate ITbTaxOilStationService stationService;private List tbTaxOrderList = null;/*** 根据取票方式和取票状态查询* @param params* @return*/@RequestMapping(value = "/getByMethodAndStatus", method = RequestMethod.POST)public ResponseVO getByReceiveMethodAndOrderStatus(@RequestBody Map params) {try{String receiveMethod = (String) params.get("receiveMethod");String orderStatus = (String) params.get("orderStatus");String stationStaffId = (String) params.get("stationStaffId");if(StringUtil.isNotEmpty(orderStatus)){String[] list = orderStatus.split(",");params.put("list",list);}if (StringUtil.isEmpty(receiveMethod) || StringUtil.isEmpty(stationStaffId)) {return ResultUtil.error("receiveMethod || stationStaffId 为空");}tbTaxOrderList = tbTaxOrderService.getByReceiveMethodAndOrderStatus(params);return ResultUtil.success(tbTaxOrderList);}catch (Exception e){e.printStackTrace();if(e instanceof TaxException){return ResultUtil.error(e.getMessage());}return ResultUtil.error();}}/*** 导出开票记录到excel* @return*/@RequestMapping(value = "/DownLoadExcel", method = RequestMethod.POST)public ResponseVO DownLoadExcel() {try{//格式化时间SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//1、创建工作簿Workbook wb = new XSSFWorkbook();//1.1、设置表格的格式----居中CellStyle cs = wb.createCellStyle();//   cs.setAlignment(HorizontalAlignment.CENTER);//2.1、创建工作表Sheet sheet = wb.createSheet("Excel download");//2.2、合并单元格
//            sheet.addMergedRegion(new CellRangeAddress(4, 8, 5, 9));//3.1、创建行----表头行Row row = sheet.createRow(0);//4、创建格Cell cell = row.createCell(0);cell.setCellValue("油卡号");cell.setCellStyle(cs);cell = row.createCell(1);cell.setCellValue("油卡手机号");cell.setCellStyle(cs);cell = row.createCell(2);cell.setCellValue("开票金额");cell.setCellStyle(cs);cell = row.createCell(3);cell.setCellValue("截止时间");cell.setCellStyle(cs);cell = row.createCell(4);cell.setCellValue("公司名称");cell.setCellStyle(cs);cell = row.createCell(5);cell.setCellValue("开票申请时间");cell.setCellStyle(cs);cell = row.createCell(6);cell.setCellValue("取票状态");cell.setCellStyle(cs);cell = row.createCell(7);cell.setCellValue("取票方式");cell.setCellStyle(cs);//5、写入实体数据if(null != tbTaxOrderList && tbTaxOrderList.size() > 0){for (int i = 0; i < tbTaxOrderList.size(); i++) {//3.2、创建行----内容行row = sheet.createRow(i+1);TbTaxOrder order = (TbTaxOrder)tbTaxOrderList.get(i);//第几行第几格  第一行第一格为“code”row.createCell(0).setCellValue(order.getCardCode());row.createCell(1).setCellValue(order.getBindPhone());if(null != order.getBillAmount()){row.createCell(2).setCellValue(order.getBillAmount().toString());}else{row.createCell(2).setCellValue("");}if(null != order.getEndDate()){String endDate = formatter.format(order.getEndDate());row.createCell(3).setCellValue(endDate);}else{row.createCell(3).setCellValue(order.getEndDate());}row.createCell(4).setCellValue(order.getCompany());String insertDate = formatter.format(order.getInsertDate());row.createCell(5).setCellValue(insertDate);if("1".toString().equals(order.getReceiveMethod())){row.createCell(6).setCellValue("未办理");}else if("2".toString().equals(order.getReceiveMethod())){row.createCell(6).setCellValue("开票中");}else if("3".toString().equals(order.getReceiveMethod())){row.createCell(6).setCellValue("开票完成");}else if("4".toString().equals(order.getReceiveMethod())){row.createCell(6).setCellValue("开票请求驳回");}else {row.createCell(6).setCellValue("已邮寄 或 已自提");}if("1".toString().equals(order.getReceiveMethod())){row.createCell(7).setCellValue("默认不选择");}else if("12".toString().equals(order.getReceiveMethod())){row.createCell(7).setCellValue("场站自取");}else{row.createCell(7).setCellValue("邮寄");}}//6、将文件储存到指定位置try {FileOutputStream fout = new FileOutputStream("D:\\" + new Date().getTime() + ".xlsx");wb.write(fout);fout.close();return ResultUtil.success("导出完成");} catch (IOException e) {e.printStackTrace();return ResultUtil.error("导出失败");}}else{return ResultUtil.error("tbTaxOrderList 不能为空");}}catch (Exception e){e.printStackTrace();if(e instanceof TaxException){return ResultUtil.error(e.getMessage());}return ResultUtil.error();}}}

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！