// Properties ///<summary> ///Gets the row with the specified name. ///</summary> ///<param name="name">The name of the row.</param> ///<example> Look at following code for cell referencing examples: ///<code lang="Visual Basic"> ///Dim ws As ExcelWorksheet = excelFile.Worksheets.ActiveWorksheet /// ///ws.Cells("B2").Value = "Cell B2." ///ws.Cells(6, 0).Value = "Cell in row 7 and column A." /// ///ws.Rows(2).Cells(0).Value = "Cell in row 3 and column A." ///ws.Rows("4").Cells("B").Value = "Cell in row 4 and column B." /// ///ws.Columns(2).Cells(4).Value = "Cell in column C and row 5." ///ws.Columns("AA").Cells("6").Value = "Cell in AA column and row 6." ///</code> ///<code lang="C#"> ///ExcelWorksheet ws = excelFile.Worksheets.ActiveWorksheet; /// ///ws.Cells["B2"].Value = "Cell B2."; ///ws.Cells[6,0].Value = "Cell in row 7 and column A."; /// ///ws.Rows[2].Cells[0].Value = "Cell in row 3 and column A."; ///ws.Rows["4"].Cells["B"].Value = "Cell in row 4 and column B."; /// ///ws.Columns[2].Cells[4].Value = "Cell in column C and row 5."; ///ws.Columns["AA"].Cells["6"].Value = "Cell in AA column and row 6."; ///</code> ///</example> public ExcelRow this[string name] { get { return(this[ExcelRowCollection.RowNameToIndex(name)]); } }
public static void SetAreaRows(string value, out ushort firstRow, out ushort lastRow) { firstRow = 0; lastRow = 0; Match match1 = AreaFormulaToken.IsCellRangeRegex.Match(value); firstRow = (ushort)ExcelRowCollection.RowNameToIndex(match1.Groups["Row1"].Value); lastRow = (ushort)ExcelRowCollection.RowNameToIndex(match1.Groups["Row2"].Value); }
private void SetRow(string row) { if (row[0] == RefFormulaToken.AbsoluteCellMark) { this.IsRowRelative = false; row = row.Substring(1); } else { this.IsRowRelative = true; } this.row = (ushort)ExcelRowCollection.RowNameToIndex(row); }
private static bool IsValidCell(Match regexMatch) { string text1 = regexMatch.Groups["Row"].Value; if (text1[0] == RefFormulaToken.AbsoluteCellMark) { text1 = text1.Remove(0, 1); } string text2 = regexMatch.Groups["Column"].Value; if (text2[0] == RefFormulaToken.AbsoluteCellMark) { text2 = text2.Remove(0, 1); } if (RefFormulaToken.IsColumnValid(ExcelColumnCollection.ColumnNameToIndex(text2))) { return(RefFormulaToken.IsRowValid(ExcelRowCollection.RowNameToIndex(text1))); } return(false); }
public static ushort CellToRow(string value) { return((ushort)ExcelRowCollection.RowNameToIndex(RefFormulaToken.IsCellRegex.Match(value).Groups["Row"].Value)); }