java 下拉框数组_java - Web开发 - POI导出带有下拉框的Excel和解决下拉中数组过多而产生的异常...

曾经蜡笔没有小新2017-05-17 10:02:251楼

下面是解决办法：

/**

* Excel API

*/

@SuppressWarnings("resource")

HSSFWorkbook book = new HSSFWorkbook();

HSSFSheet sheet = book.createSheet("spu导入模板");

/**

* 初始化参数

*/

Map map = new HashMap(); // 查询时用的map

List list = null;

String[] strs = null; // 用于下拉的数组

String hiddenSheet = null;

int cellNum = 0;

int startRow = 1; // 开始行

int endRow = 100; // 结束行

DVConstraint constraint = null;

CellRangeAddressList addressList = null;

HSSFDataValidation validation = null; // 数据验证

map.put("namespace", "xxxxxxx.xxxxx"); // 查询

list = commonQueryService.queryList(map);

strs = StringUtil.mapListToStrs(list);

hiddenSheet = "category1Hidden";

cellNum = SpuEnu.CATEGORY_1.getNumber();

HSSFSheet category1Hidden = book.createSheet(hiddenSheet); // 创建隐藏域

for (int i = 0, length = strs.length; i < length; i++) { // 循环赋值(为了防止下拉框的行数与隐藏域的行数相对应来获取>=选中行数的数组，将隐藏域加到结束行之后)

category1Hidden.createRow(endRow + i).createCell(cellNum).setCellValue(strs[i]);

}

Name category1Name = book.createName();

category1Name.setNameName(hiddenSheet);

category1Name.setRefersToFormula(hiddenSheet + "!A1:A" + (strs.length + endRow)); // A1:A代表隐藏域创建第?列createCell(?)时。以A1列开始A行数据获取下拉数组

constraint = DVConstraint.createFormulaListConstraint(hiddenSheet);

addressList = new CellRangeAddressList(startRow, endRow, cellNum, cellNum);

validation = new HSSFDataValidation(addressList, constraint);

book.setSheetHidden(1, true); // 1隐藏、0显示

sheet.addValidationData(validation);

请注意上面的这俩个地方：