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); }