java - 如何读取Excel单元格值中的下拉列表项？

Question

我已在同一单元格中保存了相同类型的联系方式(例如，一个人有多个电子邮件地址)我已将它们保存为一个单元格中的列表，但在迭代 Excel 时我无法读取它们床单。我只能读取当前选择/显示的选项，其他选项将被忽略。我正在使用java

//Read sheet inside the workbook by its name

Sheet _workSheet = _workbook.getSheet(sheetName);

//Iterate through each rows
Iterator<Row> rowIterator = _workSheet.iterator();

while(rowIterator.hasNext())
{
    //Get Each Row
    Row row_ = rowIterator.next();

    //Iterator through each column of each row
    Iterator<Cell> cellIterator = row_.cellIterator();

    while(cellIterator.hasNext())
    {
        Cell cell = cellIterator.next();                         

        //Checking the cell format
        switch(cell.getCellType())
        {
            case Cell.CELL_TYPE_NUMERIC:
                System.out.println(cell.getNumericCellValue()+"\n");
                break;

            case Cell.CELL_TYPE_STRING:
                System.out.println(cell.getStringCellValue()+"\n");
                break;

            case Cell.CELL_TYPE_BOOLEAN:
                System.out.println(cell.getBooleanCellValue()+"\n");
                break;

            case Cell.CELL_TYPE_BLANK:
                System.err.println(cell.getStringCellValue()+" .....empty cell");
                break;
        }
    }
    System.err.println("");

}

在单元格“A2”中，我期望获得两个值(emailone、emailTwo)

Answer 1

These did the trick;
List<XSSFDataValidation> dataValidations = sheet.getDataValidations();
            Iterator<XSSFDataValidation> iterator = dataValidations.iterator();
            XSSFDataValidation dataValidation = iterator.next();
            String[] explicitListValues = dataValidation.getValidationConstraint().getExplicitListValues();