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