使用java apache poi动态读写excel文件中特定列的数据。

<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>

Workbook workbook = new XSSFWorkbook(new FileInputStream("path/to/excel.xlsx"));

Sheet sheet = workbook.getSheet("Sheet1"); // 根据名称获取Sheet对象
// 或
Sheet sheet = workbook.getSheetAt(0); // 根据索引获取Sheet对象，索引从0开始

int columnIndex = 0; // 特定列的索引，从0开始
for (Row row : sheet) {
    Cell cell = row.getCell(columnIndex);
    String cellValue = cell.getStringCellValue();
    System.out.println(cellValue);
}

int columnIndex = 0; // 特定列的索引，从0开始
for (Row row : sheet) {
    Cell cell = row.getCell(columnIndex);
    cell.setCellValue("New Value");
}

workbook.write(new FileOutputStream("path/to/modified_excel.xlsx"));
workbook.close();