public static ExcelRangeBase MoveColumn(this ExcelRangeBase cell, int offset)
{
var newCellIndex = cell.GetRangeIndex().MoveColumn(offset);
var newCell = cell.Worksheet.GetRange(newCellIndex);
return(newCell);
}
/// <summary>
/// Expand the current range to new index, only expand row range
/// </summary>
/// <param name="cell">cell of current range</param>
/// <param name="offset">positive for down expandation, negative for up expandation</param>
/// <returns>The <paramref name="ExcelRangeBase"/> with new index</returns>
public static ExcelRangeBase ExpandRow(this ExcelRangeBase cell, int offset)
{
var newCellIndex = cell.GetRangeIndex().ExpandRow(offset);
var newCell = cell.Worksheet.GetRange(newCellIndex);
return(newCell);
}
public static ExcelRangeBase MoveOffset(this ExcelRangeBase cell, string indecator, string FillOfX)
{
ExcelRangeBase newCell = null;
if (indecator[1].Equals('X'))
{
}
else
{
var index = int.Parse(indecator[1].ToString());
if (indecator.Contains("v", "^"))
{
if (indecator[0].Equals('^'))
{
index = -index;
}
var newCellIndex = cell.GetRangeIndex().MoveRow(index);
newCell = cell.Worksheet.GetRange(newCellIndex);
}
if (indecator.Contains("<", ">"))
{
if (indecator[0].Equals('<'))
{
index = -index;
}
var newCellIndex = cell.GetRangeIndex().MoveColumn(index);
newCell = cell.Worksheet.GetRange(newCellIndex);
}
}
return(newCell);
}