在 Cell 上应用验证

您可以使用 Aspose.Cells API 将验证应用于任何单元格。 Aspose.Cells 提供了[Cell.getValidation](https://reference.aspose.com/cells/java/com.aspose.cells/cell#getValidation() 方法用于此目的。如果单元格没有验证，则返回 null。同样，您可以使用Worksheet.getValidations().getValidationInCell(int row, int column) 方法通过提供其行和列索引来获取应用于单元格的验证。

以下快照显示了以下示例代码中使用的示例 Microsoft Excel 文件。 CellC1已十进制验证已应用且只能取值10 到 20 之间.

具有验证功能的单元格

待办事项：图片_替代_文本

下面的示例代码获取应用于 C1 的验证并读取其各种属性。

	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
	// The path to the documents directory.
	String dataDir = Utils.getDataDir(GetValidationAppliedonCell.class);
	// Instantiate the workbook from sample Excel file
	Workbook workbook = new Workbook(dataDir + "book1.xlsx");

	// Access its first worksheet
	Worksheet worksheet = workbook.getWorksheets().get(0);

	// Cell C1 has the Decimal Validation applied on it.
	// It can take only the values Between 10 and 20
	Cell cell = worksheet.getCells().get("C1");

	// Access the valditation applied on this cell
	Validation validation = cell.getValidation();

	// Read various properties of the validation
	System.out.println("Reading Properties of Validation");
	System.out.println("--------------------------------");
	System.out.println("Type: " + validation.getType());
	System.out.println("Operator: " + validation.getOperator());
	System.out.println("Formula1: " + validation.getFormula1());
	System.out.println("Formula2: " + validation.getFormula2());
	System.out.println("Ignore blank: " + validation.getIgnoreBlank());

这是使用上面快照中显示的示例文件执行的示例代码的控制台输出。

Reading Properties of Validation

\--------------------------------

Type: 2

Operator: 0

Formula1: =10

Formula2: =20

Ignore blank: true

相关文章