Sheet validity check

Aspose.Cells Product Family
1

Hi,
How can i check validity of sheet?
I mean, i created an excel file with some data validation on cells. is there any way to check all cells are valid when i open that file in c# code?

thanks.

2

Hi,


Please see the document/ article on how to verify if a cell satisfies data validation or not (you may adopt the similar approach to check your desired range of cells’ data validations):
http://www.aspose.com/docs/display/cellsnet/Verify+that+Cell+Value+satisfies+Data+Validation+Rules

Thank you.

3

Thank you Amjad, it helps.
But in this approach, every time i want to check validity of a sheet, i should iterate on all sheet’s cells and call GetValidationValue method of cell.
i think it was better that we have a property or a method on sheet object for this.

Thank you for your time and help.

4

Hi,


Well, I am afraid, you have to iterate your desired range of cells to check if the cells satisfy data validation rules or not. It might not be feasible to provide single method to do so, because if we add a method we will also include all those cells in the loop to check the validity.

Anyways, we will further check if it is feasible enough to be supported.

Thank you.
5

Hi,
Thank you for your support.