POI 生成Excel时,怎么限制 单元格输入长度的限制啊?
[code="java"] public static void main(String[] args) {
FileOutputStream out = null;
try {
// excel对象
HSSFWorkbook wb = new HSSFWorkbook();
// sheet对象
HSSFSheet sheet = wb.createSheet("sheet1");
// 输出excel对象
out = new FileOutputStream("C://test.xls");
// 取得规则
HSSFDataValidation validate = setValidate((short) 1,
(short) 1, (short) 1, (short) 1);
// 设定规则
sheet.addValidationData(validate);
// 输出excel
wb.write(out);
out.close();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
if (out != null) {
try {
out.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
public static HSSFDataValidation setValidate(short beginRow,
short beginCol, short endRow, short endCol) {
DVConstraint constraint = DVConstraint.createNumericConstraint(
DVConstraint.ValidationType.TEXT_LENGTH,
DVConstraint.OperatorType.BETWEEN, "1", "5");
// 设定在哪个单元格生效
CellRangeAddressList regions = new CellRangeAddressList(beginRow,
beginCol, endRow, endCol);
// 创建规则对象
HSSFDataValidation ret = new HSSFDataValidation(regions, constraint);
return ret;
}[/code]
加 数据有效性
CellRangeAddressList regions = new CellRangeAddressList(beginRow, beginCol, endRow, endCol);
参数命名错了。。。。