Java Excel 多Sheet导出工具 - Apache POI 示例代码

以下是一个Java代码导出Excel多个Sheet的工具类的示例代码：\n\njava\nimport org.apache.poi.ss.usermodel.*;\nimport org.apache.poi.xssf.usermodel.XSSFWorkbook;\n\nimport java.io.FileOutputStream;\nimport java.io.IOException;\nimport java.util.List;\n\npublic class ExcelExportUtil {\n \n public static void exportToExcel(List<List<String>> data, List<String> sheetNames, String filePath) throws IOException {\n Workbook workbook = new XSSFWorkbook();\n \n for (int i = 0; i < data.size(); i++) {\n Sheet sheet = workbook.createSheet(sheetNames.get(i));\n List<String> sheetData = data.get(i);\n \n for (int j = 0; j < sheetData.size(); j++) {\n Row row = sheet.createRow(j);\n Cell cell = row.createCell(0);\n cell.setCellValue(sheetData.get(j));\n }\n }\n \n FileOutputStream fileOutputStream = new FileOutputStream(filePath);\n workbook.write(fileOutputStream);\n fileOutputStream.close();\n workbook.close();\n }\n \n public static void main(String[] args) {\n List<List<String>> data = List.of(\n List.of("Sheet1 Data 1", "Sheet1 Data 2", "Sheet1 Data 3"),\n List.of("Sheet2 Data 1", "Sheet2 Data 2", "Sheet2 Data 3")\n );\n List<String> sheetNames = List.of("Sheet1", "Sheet2");\n String filePath = "output.xlsx";\n \n try {\n exportToExcel(data, sheetNames, filePath);\n System.out.println("Excel exported successfully.");\n } catch (IOException e) {\n System.out.println("Failed to export Excel: " + e.getMessage());\n }\n }\n}\n\n\n这个工具类使用了Apache POI库来处理Excel文件。exportToExcel方法接受一个包含数据的二维List，一个包含Sheet名称的List，以及要导出的Excel文件路径。它会根据提供的数据和Sheet名称创建相应的Sheet，并将数据写入到每个Sheet中。\n\n在main方法中，我们提供了一个示例数据和Sheet名称，然后调用exportToExcel方法将数据导出到Excel文件中。