在java中根据列名从excel中获取列值。

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

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileInputStream;
import java.io.InputStream;

public class ExcelUtils {
    public static String getCellValueByColumnName(String filePath, String sheetName, String columnName) {
        String cellValue = null;
        
        try (InputStream inputStream = new FileInputStream(filePath);
             Workbook workbook = new XSSFWorkbook(inputStream)) {
            
            Sheet sheet = workbook.getSheet(sheetName);
            Row headerRow = sheet.getRow(0);
            int columnIndex = -1;
            
            for (Cell cell : headerRow) {
                if (cell.getStringCellValue().equals(columnName)) {
                    columnIndex = cell.getColumnIndex();
                    break;
                }
            }
            
            if (columnIndex != -1) {
                Row dataRow = sheet.getRow(1);
                Cell dataCell = dataRow.getCell(columnIndex);
                
                if (dataCell != null) {
                    switch (dataCell.getCellType()) {
                        case STRING:
                            cellValue = dataCell.getStringCellValue();
                            break;
                        case NUMERIC:
                            cellValue = String.valueOf(dataCell.getNumericCellValue());
                            break;
                        case BOOLEAN:
                            cellValue = String.valueOf(dataCell.getBooleanCellValue());
                            break;
                        default:
                            // Handle other cell types if needed
                            break;
                    }
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        
        return cellValue;
    }
}

String filePath = "path/to/your/excel.xlsx";
String sheetName = "Sheet1";
String columnName = "Column1";

String cellValue = ExcelUtils.getCellValueByColumnName(filePath, sheetName, columnName);
System.out.println("Cell value: " + cellValue);