本文整理了Java中org.apache.poi.ss.usermodel.Sheet.getDataValidationHelper()
方法的一些代码示例,展示了Sheet.getDataValidationHelper()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Sheet.getDataValidationHelper()
方法的具体详情如下:
包路径:org.apache.poi.ss.usermodel.Sheet
类名称: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);
内容来源于网络,如有侵权,请联系作者删除!