public ICell CellMatch(String regex)
{
return(Rows.Get().Select(row => row.Value.First(pair => pair.Value.GetText().Matches(regex)).Value).FirstOrDefault(result => result != null));
}
public List <string> RowValue(string rowName)
{
return(Rows.GetRowValue(rowName));
}
public ICell Cell(string value)
{
return(Rows.Get().Select(row => row.Value.First(pair => pair.Value.GetText().Equals(value)).Value).FirstOrDefault(result => result != null));
}
public List <string> RowValue(int rowNum)
{
return(Rows.GetRowValue(rowNum));
}
public Dictionary <string, ICell> Row(string rowName)
{
return(Rows.GetRow(rowName));
}
public Dictionary <string, ICell> Row(int rowNum)
{
return(Rows.GetRow(rowNum));
}
private object Row(string value, Column column)
{
ICell rowCell = Cell(value, column);
return(rowCell != null?Rows.GetRow(rowCell.RowNum()) : null);
}
public void Clean()
{
AllCells = new List <ICell>();
Columns.Clean();
Rows.Clean();
}
