public void TestValidation()
{
var table = new List <List <object> >();
table.Add(new List <object> {
7657, 1, 2, 3, "2016-09-12"
});
table.Add(new List <object> {
0, 1, 2, 3, "2016-09-12"
});
table.Add(new List <object> {
0, 1, 2, 3, "2016/09/12"
});
table.Add(new List <object> {
0, "123.5", 2, 3, "2016-09-12"
});
table.Add(new List <object> {
0, "123.5", 2, 3, "2016-09-12"
});
table.Add(new List <object> {
0, "23.5", 2, 3, "2016-09-12"
});
table.Add(new List <object> {
0, "23.5", 2, 3, "2016-09-12"
});
var validation = new ExcelValidation();
validation.Add(CellRange.Cell(0, 0), new CellTextValidation(0, 10));
validation.Add(CellRange.Column(4), new CellTextValidation(0, 10));
validation.Add(CellRange.Column(1), new CellNumberValidation());
validation.Add(CellRange.Column(4), new CellDateValidation());
validation.Add(CellRange.Row(6), new CellNumberValidation());
var tableHeaderRowsCount = 1;
validation.Check(table, tableHeaderRowsCount);
}
