很详细,很简单。
https://www.cnblogs.com/gudongcheng/p/8268909.html
// 设置下拉列表 1.第几行开始,2.第几行结束,3.第几列开始,4.第几列结束
CellRangeAddressList regions = new CellRangeAddressList(0, 50, downRows, downRows);
// 创建下拉列表数据 String[] downData 下拉数据
DVConstraint constraint = DVConstraint.createExplicitListConstraint(downData);
// 绑定
HSSFDataValidation dataValidation = new HSSFDataValidation(regions, constraint);
sheet.addValidationData(dataValidation);