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

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

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

Sheet.addValidationData介绍

[英]Creates a data validation object
[中]创建数据验证对象

代码示例

代码示例来源：origin: lerry903/RuoYi

/**
 * 设置某些列的值只能输入预制的数据,显示下拉框.
 *
 * @param sheet    要设置的sheet.
 * @param textList 下拉框显示的内容
 * @param firstCol 开始列
 * @param endCol   结束列
 */
private static void setHSSFValidation(Sheet sheet, String[] textList,
                   int firstCol, int endCol) {
  // 加载下拉列表内容
  DVConstraint constraint = DVConstraint.createExplicitListConstraint(textList);
  // 设置数据有效性加载在哪个单元格上,四个参数分别是：起始行、终止行、起始列、终止列
  CellRangeAddressList regions = new CellRangeAddressList(1, 100, firstCol, endCol);
  // 数据有效性对象
  HSSFDataValidation dataValidationList = new HSSFDataValidation(regions, constraint);
  sheet.addValidationData(dataValidationList);
}

代码示例来源：origin: lerry903/RuoYi

/**
 * 设置单元格上提示
 *
 * @param sheet         要设置的sheet.
 * @param promptTitle   标题
 * @param promptContent 内容
 * @param firstCol      开始列
 * @param endCol        结束列
 */
private static void setHSSFPrompt(Sheet sheet, String promptTitle, String promptContent,
                 int firstCol, int endCol) {
  // 构造constraint对象
  DVConstraint constraint = DVConstraint.createCustomFormulaConstraint("DD1");
  // 四个参数分别是：起始行、终止行、起始列、终止列
  CellRangeAddressList regions = new CellRangeAddressList(1, 100, firstCol, endCol);
  // 数据有效性对象
  HSSFDataValidation dataValidationView = new HSSFDataValidation(regions, constraint);
  dataValidationView.createPromptBox(promptTitle, promptContent);
  sheet.addValidationData(dataValidationView);
}

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

DataValidationConstraint dvConstraint = dvHelper.createFormulaListConstraint("CHOICES");
DataValidation validation = dvHelper.createValidation(dvConstraint, addressList);
sheet.addValidationData(validation);
    "INDIRECT(UPPER($A$1))");
validation = dvHelper.createValidation(dvConstraint, addressList);
sheet.addValidationData(validation);

代码示例来源：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: hyberbin/J-Excel

workbook.setSheetHidden(workbook.getSheetIndex(DICCODE_SHEET_NAME), Workbook.SHEET_STATE_VERY_HIDDEN);
setValidationTip(validation,config);
sheet.addValidationData(validation);
log.debug("用引用方式设置码表完毕");

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

dataValidation.setErrorStyle(ErrorStyle.STOP);
sheet.addValidationData(dataValidation);

代码示例来源：origin: hyberbin/J-Excel

/**
 * 数据有效性自定义序列适配器
 * @param dataBean
 * @param sheet
 * @param columnIndex
 * @param filedName
 */
public void DicCodeValidateAdapter(DataBean dataBean, Sheet sheet, int columnIndex, String filedName) {
  DicValidateConfig config = dataBean.getValidateConfig(filedName);
  String dicCode = config.dicCode();
  Set<String> set = dicCodePool.getDicValueSet().get(dicCode);
  if (ObjectHelper.isEmpty(set)) {
    log.error("找不到字典：{}", dicCode);
    return;
  }
  if (config.columnName()!=0) {//表示是引用的形式
    createDicCodeSheet(config, sheet, columnIndex, set);
  } else {
    String[] strings = set.toArray(new String[]{});
    DVConstraint constraint = DVConstraint.createExplicitListConstraint(strings);
    // 设置数据有效性加载在哪个单元格上,四个参数分别是：起始行、终止行、起始列、终止列
    CellRangeAddressList regions = new CellRangeAddressList(BaseExcelService.START_ROW, Short.MAX_VALUE, columnIndex, columnIndex);
    // 数据有效性对象
    HSSFDataValidation data_validation_list = new HSSFDataValidation(regions, constraint);
    setValidationTip(data_validation_list,config);
    sheet.addValidationData(data_validation_list);
  }
}

代码示例来源：origin: hyberbin/J-Excel

/**
 * 数字校验适配器
 * @param dataBean
 * @param sheet
 * @param columnIndex
 * @param filedName
 */
public void NumericValidateAdapter(DataBean dataBean, Sheet sheet, int columnIndex, String filedName) {
  NumericValidateConfig config = dataBean.getValidateConfig(filedName);
  DVConstraint constraint = DVConstraint.createNumericConstraint(DataValidationConstraint.ValidationType.DECIMAL, DataValidationConstraint.OperatorType.BETWEEN, config.min(), config.max());
  // 设置数据有效性加载在哪个单元格上,四个参数分别是：起始行、终止行、起始列、终止列
  CellRangeAddressList regions = new CellRangeAddressList(BaseExcelService.START_ROW, Short.MAX_VALUE, columnIndex, columnIndex);
  // 数据有效性对象
  DataValidation data_validation_list = new HSSFDataValidation(regions, constraint);
  setValidationTip(data_validation_list,config);
  sheet.addValidationData(data_validation_list);
}

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

validation.setSuppressDropDownArrow(true);
 validation.setShowErrorBox(true);
 sheet.addValidationData(validation);
} else if (sheet instanceof HSSFSheet) {
 CellRangeAddressList addressList = new CellRangeAddressList(firstRow, lastRow, firstCol,
 validation.setSuppressDropDownArrow(true);
 validation.setShowErrorBox(true);
 sheet.addValidationData(validation);

代码示例来源：origin: hyberbin/J-Excel

/**
 * 数字校验适配器
 * @param dataBean
 * @param sheet
 * @param columnIndex
 * @param filedName
 */
public void IntegerValidateAdapter(DataBean dataBean, Sheet sheet, int columnIndex, String filedName) {
  IntValidateConfig config = dataBean.getValidateConfig(filedName);
  DVConstraint constraint = DVConstraint.createNumericConstraint(DataValidationConstraint.ValidationType.INTEGER, DataValidationConstraint.OperatorType.BETWEEN, config.min(), config.max());
  // 设置数据有效性加载在哪个单元格上,四个参数分别是：起始行、终止行、起始列、终止列
  CellRangeAddressList regions = new CellRangeAddressList(BaseExcelService.START_ROW, Short.MAX_VALUE, columnIndex, columnIndex);
  // 数据有效性对象
  DataValidation data_validation_list = new HSSFDataValidation(regions, constraint);
  setValidationTip(data_validation_list,config);
  sheet.addValidationData(data_validation_list);
}

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

validation.setSuppressDropDownArrow(true);
sheet.addValidationData(validation);

代码示例来源：origin: hyberbin/J-Excel

/**
 * 长度校验适配器
 * @param dataBean
 * @param sheet
 * @param columnIndex
 * @param filedName
 */
public void TextValidateAdapter(DataBean dataBean, Sheet sheet, int columnIndex, String filedName) {
  TextValidateConfig config = dataBean.getValidateConfig(filedName);
  if (config.length() != 0) {
    DVConstraint constraint = DVConstraint.createNumericConstraint(
        DVConstraint.ValidationType.TEXT_LENGTH,
        DVConstraint.OperatorType.LESS_OR_EQUAL, config.length() + "", null);
    // 设置数据有效性加载在哪个单元格上,四个参数分别是：起始行、终止行、起始列、终止列
    CellRangeAddressList regions = new CellRangeAddressList(BaseExcelService.START_ROW, Short.MAX_VALUE, columnIndex, columnIndex);
    // 数据有效性对象
    DataValidation data_validation_list = new HSSFDataValidation(regions, constraint);
    setValidationTip(data_validation_list,config);
    sheet.addValidationData(data_validation_list);
  }
}

代码示例来源：origin: hyberbin/J-Excel

/**
 * 时间校验适配器
 * @param dataBean
 * @param sheet
 * @param columnIndex
 * @param filedName
 */
public void DateValidateAdapter(DataBean dataBean, Sheet sheet, int columnIndex, String filedName) {
  DateValidateConfig config = dataBean.getValidateConfig(filedName);
  DVConstraint dateConstraint = DVConstraint.createDateConstraint(DataValidationConstraint.OperatorType.BETWEEN, config.min(),config.max(),  config.format());
  // 设置数据有效性加载在哪个单元格上,四个参数分别是：起始行、终止行、起始列、终止列
  CellRangeAddressList regions = new CellRangeAddressList(BaseExcelService.START_ROW, Short.MAX_VALUE, columnIndex, columnIndex);
  // 数据有效性对象
  DataValidation data_validation_list = new HSSFDataValidation(regions, dateConstraint);
  setValidationTip(data_validation_list,config);
  sheet.addValidationData(data_validation_list);
}

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

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

内容来源于网络，如有侵权，请联系作者删除！

sheet

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    Sheet类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com