使用Poi导出Excel表时设置下拉列表

使用poi导出Excel文件并设置下拉数据

设置下拉框

		String[] capacityAvi = {"是","否"};
		Sheet sheet = writer.getSheet();
		//需要被设置为下拉数据的单元格范围
		CellRangeAddressList capacityList = new CellRangeAddressList(3, 5000, 3, 3);
		StyleSet styleSet = writer.getStyleSet();
		CellStyle cellStyle = styleSet.getCellStyle();
		//规定格式
		cellStyle.setDataFormat((short)BuiltinFormats.getBuiltinFormat("text"));
		DataValidationHelper helper = sheet.getDataValidationHelper();
		// 设置辅修下拉框数据
		DataValidationConstraint capacityConstraint = helper.createExplicitListConstraint(capacityAvi);
		DataValidation capacityDataValidation = helper.createValidation(capacityConstraint, capacityList);
		writer.addValidationData(capacityDataValidation);