XlsFile.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.XlsAdapter
public override 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.