public static void exportDispatches(String fileName, List<Dispatch> dispatchList) { logger.info("Export Dispatches to excel"); ExcelGenerator generator = new ExcelGenerator(fileName); List<String[]> headerList = new ArrayList<>(); List<String> sheetNames = new ArrayList<>(); sheetNames.add("菜品配送"); headerList.add(new String[] {"菜品", "总量", "单位", "配送信息"}); List<List<String[]>> contents = new ArrayList<>(); List<String[]> content = new ArrayList<>(); for (Dispatch dispatch : dispatchList) { content.add( new String[] { dispatch.getProduct().getName(), String.valueOf(dispatch.getQuantity()), dispatch.getUnit(), formatDispatchList(dispatch.getOrderInfoList()) }); } contents.add(content); try { generator.generate4Dispatches(sheetNames, headerList, contents); } catch (IOException e) { e.printStackTrace(); return; } }