如何使用Java POI实现高效的数据导入导出操作？

本文共计384个文字，预计阅读时间需要2分钟。

导入POI库的依赖项，在项目中添加以下Maven依赖项：

xml org.apache.poi poi 4.1.2 org.apache.poi poi-ooxml 4.1.2

1. 导入POI库的依赖项，在项目中加入以下Maven依赖项：

<dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>4.1.2</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>4.1.2</version> </dependency>

2. 导入所需的POI类：

import org.apache.poi.ss.usermodel.*; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFRow; import org.apache.poi.xssf.usermodel.XSSFCell;

3. 实现导出功能：

public class ExcelExporter { public static void exportData(List<List<String>> data, String filePath) { try (Workbook workbook = new XSSFWorkbook()) { Sheet sheet = workbook.createSheet("Sheet1"); int rowNum = 0; for (List<String> rowData : data) { Row row = sheet.createRow(rowNum++); int colNum = 0; for (String cellData : rowData) { Cell cell = row.createCell(colNum++); cell.setCellValue(cellData); } } try (FileOutputStream outputStream = new FileOutputStream(filePath)) { workbook.write(outputStream); } } catch (IOException e) { e.printStackTrace(); } } }

4. 实现导入功能：

public class ExcelImporter { public static List<List<String>> importData(String filePath) { List<List<String>> data = new ArrayList<>(); try (Workbook workbook = WorkbookFactory.create(new File(filePath))) { Sheet sheet = workbook.getSheetAt(0); for (Row row : sheet) { List<String> rowData = new ArrayList<>(); for (Cell cell : row) { rowData.add(cell.getStringCellValue()); } data.add(rowData); } } catch (IOException | InvalidFormatException e) { e.printStackTrace(); } return data; } }

以上代码示例展示了如何使用POI库实现Excel文件的导入和导出功能。可以根据自己的需求进行修改和扩展。