HSSFSheet Excel导出，设置单元格下拉选择

private static HSSFSheet buildDataSheet(HSSFWorkbook workbook) {
	//创建sheet
	HSSFSheet sheet = workbook.createSheet();
	sheet = dataEffective(workbook.createSheet());
}

private static HSSFSheet dataEffective(HSSFSheet sheet) {
    	
    	//获取分类名称
    	List<String> categoryNameList = categoryService.getAllName();
    	String[] categoryNames = categoryNameList.toArray(new 			String[categoryNameList.size()]);
    	//资产分类有效性
    	//String[] categoryDatas = new String[] {"房屋","土地","车辆","仪器","设备"};
        DVConstraint categoryConstraint = DVConstraint
                .createExplicitListConstraint(categoryNames);//textlist  下拉选项的 数组 如{列表1，列表2，。。。。。}
        // 设置数据有效性加载在哪个单元格上,四个参数分别是：起始行、终止行、起始列、终止列
        CellRangeAddressList categoryRegions = new CellRangeAddressList(1, 200, 2, 2);
        // 数据有效性对象
        HSSFDataValidation categoryDataValidationList = new    HSSFDataValidation(categoryRegions, categoryConstraint);
        sheet.addValidationData(categoryDataValidationList);
    	
    	return sheet;
    }

效果展示