获取应用于单元格的验证

您可以使用Aspose.Cells获取应用于单元格的验证。Aspose.Cells为此提供了Cell.GetValidation()方法。如果单元格上没有应用验证，则返回null。

同样，您可以使用 Worksheet.Validations.GetValidationInCell 方法通过提供它的行和列索引来获取应用于单元格的验证。

用于获取单元格上应用的验证的C#代码

下面的代码示例演示了如何获取应用于单元格的验证。

	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
	// The path to the documents directory.
	string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

	// Instantiate the workbook from sample Excel file
	Workbook workbook = new Workbook(dataDir + "sample.xlsx");

	// Access its first worksheet
	Worksheet worksheet = workbook.Worksheets[0];

	// Cell C1 has the Decimal Validation applied on it. It can take only the values Between 10 and 20
	Cell cell = worksheet.Cells["C1"];

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

	// Read various properties of the validation
	Console.WriteLine("Reading Properties of Validation");
	Console.WriteLine("--------------------------------");
	Console.WriteLine("Type: " + validation.Type);
	Console.WriteLine("Operator: " + validation.Operator);
	Console.WriteLine("Formula1: " + validation.Formula1);
	Console.WriteLine("Formula2: " + validation.Formula2);
	Console.WriteLine("Ignore blank: " + validation.IgnoreBlank);