public ICell Cell(string value, Row row)
{
var rowNum = row.HasName ? Rows.Headers.IndexOf(row.Name) + 1 : row.Num;
return(Rows.GetRow(rowNum).FirstOrDefault(pair => pair.Value.Value.Equals(value)).Value);
}
public ICell CellMatch(string regex)
{
return(Rows.Get().Select(row => row.Value.FirstOrDefault(pair => pair.Value.GetText.Matches(regex)).Value).FirstOrDefault(result => result != null));
}
public IList <string> RowValue(string rowName)
{
return(Rows.GetRowValue(rowName));
}
public ICell Cell(string value)
{
return(Rows.Get().Select(row => row.Value.FirstOrDefault(pair => pair.Value.GetText.Equals(value)).Value).FirstOrDefault(result => result != null));
}
public IList <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));
}
public Dictionary <string, ICell> Row(string value, Column column)
{
var rowCell = Cell(value, column);
return(rowCell != null?Rows.GetRow(rowCell.RowNum) : null);
}
public void Clean()
{
AllCells = new List <ICell>();
Columns.Clean();
Rows.Clean();
}
