POI 生成Excel时，怎么限制 单元格输入长度的限制啊？

Question

POI 生成Excel时，怎么限制 单元格输入长度的限制啊？

Answer 1

[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]