添加依赖spire.xls.jar,用下面的代码
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;
public class ReadCellContent {
public static void main(String[] args) {
//创建Workbook对象
Workbook wb = new Workbook();
//加载Excel文档
wb.loadFromFile("G:\\360MoveData\\Users\\Administrator\\Desktop\\test.xlsx");
//获取第一个表格
Worksheet worksheet = wb.getWorksheets().get(0);
//获取指定单元格内下拉列表的值
String[] values = worksheet.getCellRange(7,3).getDataValidation().getValues();
for (int i = 0; i < values.length; i++) {
System.out.println(values[i]);
}
}
}
测试结果: