Get Validation Applied on a Cell

You can use Aspose.Cells to get the validation applied to a cell. Aspose.Cells provides the Cell.GetValidation() method for this purpose. If there is no validation applied on the cell, it returns null.

Similarly, you can use Worksheet.Validations.GetValidationInCell method to acquire the validation applied to a cell by providing its row and column indices.

C# code to get the validation applied on a Cell

Below code sample, shows you how to get validation applied on a cell.

// 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);

Related Articles

• Data Validation