org.apache.poi.ss.usermodel.Sheet.getDataValidationHelper()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(2.0k)|赞(0)|评价(0)|浏览(237)

本文整理了Java中org.apache.poi.ss.usermodel.Sheet.getDataValidationHelper()方法的一些代码示例,展示了Sheet.getDataValidationHelper()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Sheet.getDataValidationHelper()方法的具体详情如下:
包路径:org.apache.poi.ss.usermodel.Sheet
类名称:Sheet
方法名:getDataValidationHelper

Sheet.getDataValidationHelper介绍

暂无

代码示例

代码示例来源:origin: asakusafw/asakusafw

private static void setExplicitListConstraint(
      Sheet sheet,
      String[] list,
      int firstRow, int firstCol,
      int lastRow, int lastCol) {
    assert sheet != null;
    assert list != null;
    DataValidationHelper helper = sheet.getDataValidationHelper();
    CellRangeAddressList addressList = new CellRangeAddressList(firstRow, lastRow, firstCol, lastCol);
    DataValidationConstraint constraint = helper.createExplicitListConstraint(list);
    DataValidation validation = helper.createValidation(constraint, addressList);
    validation.setEmptyCellAllowed(true);
    sheet.addValidationData(validation);
  }
}

代码示例来源:origin: org.apache.poi/poi-examples

DataValidationHelper dvHelper = sheet.getDataValidationHelper();
DataValidationConstraint dvConstraint = dvHelper.createFormulaListConstraint("CHOICES");
DataValidation validation = dvHelper.createValidation(dvConstraint, addressList);

代码示例来源:origin: stackoverflow.com

DataValidationHelper dvHelper = sheet.getDataValidationHelper();
DataValidationConstraint dvConstraint = dvHelper.createNumericConstraint(
DataValidationConstraint.ValidationType.INTEGER,

代码示例来源:origin: hellojavaer/poi-excel-utils

DataValidation newDataValidation = sheet.getDataValidationHelper().createValidation(dataValidation.getValidationConstraint(),
                                          newCellRangeAddressList);
sheet.addValidationData(newDataValidation);

代码示例来源:origin: cn.bestwu.simpleframework/simpleframework-web

String[] explicitListValues) {
if (sheet instanceof XSSFSheet || sheet instanceof SXSSFSheet) {
 DataValidationHelper dvHelper = sheet.getDataValidationHelper();
 XSSFDataValidationConstraint dvConstraint = (XSSFDataValidationConstraint) dvHelper
   .createExplicitListConstraint(explicitListValues);

相关文章

微信公众号

最新文章

更多