ExcelFile.CheckDataValidationsInSheet Method
Checks if all the cells in the active sheet inside data validations have values that are valid according to the data validation specifications.
Syntax
Namespace: FlexCel.Core
public abstract TCellAddress[] CheckDataValidationsInSheet(Int32 sheet, Int32 maxErrors)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
sheet | Int32 | Sheet to check (1 based) | |
maxErrors | Int32 | The maximum number of errors reported by this method. To avoid getting a too big list, set it to a number like 100. If set to 0 or a negative number, the full list of errors will be returned, which can be very big. |
Returns
An array with the first maxErrors cells that do not conform to the data validation. And empty array if all the cells conform.