java poi excel导入模板设置下拉框

最新推荐文章于 2024-09-19 12:02:28 发布

weixin_30301183

最新推荐文章于 2024-09-19 12:02:28 发布

阅读量580

点赞数

文章标签： java

原文链接：http://www.cnblogs.com/BobXie85/p/10838506.html

版权

import org.apache.poi.hssf.usermodel.DVConstraint;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFDataValidation;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.util.CellRangeAddressList;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;


// 初始一个workbook
HSSFWorkbook workbook = new  HSSFWorkbook();
// 创建一个sheet
HSSFSheet sheet=  workbook.createSheet();
// 创建行
HSSFRow row= sheet.createRow(0);
// 创建列
HSSFCell cell= row.createCell(index++);
// 准备下拉列表数据
List<BasicDBObject> options = (List<BasicDBObject>) bo.get("options");
String[] optionArr = new String[options.size()];
for (int i = 0; i < options.size(); i++) {
    optionArr[i] = options.get(i).getString("value");
}
// 设置第一列的1-10000行为下拉列表
CellRangeAddressList regions = new CellRangeAddressList(0, 10000, 0, 0);
// 创建下拉列表数据
DVConstraint constraint = DVConstraint.createExplicitListConstraint(optionArr);
// 绑定
HSSFDataValidation dataValidation = new HSSFDataValidation(regions, constraint);
sheet.addValidationData(dataValidation);