public static RangeReference CreateRangeReference(string baseRange, int offsetCol, int rowNumber) { var selectedRowRange = new RangeReference(baseRange); selectedRowRange .From.OffsetCol(offsetCol) .From.ReplaceRow(rowNumber) .ToSameAsFrom(); return(selectedRowRange); }
public CellReference(string a1Notation, RangeReference RangeReference = null) { if (string.IsNullOrEmpty(a1Notation)) { return; } Match m = regex.Match(a1Notation); if (m.Success) { Col = m.Groups[1].Value; Row = m.Groups[2].Value; } else { Col = a1Notation; } rangeReference = RangeReference; }