public static void FreezePanes(Excel app, Range range)
{
range.XlRange.Worksheet.Select();
range.XlRange.Select();
ExcelOperations.FreezePanes(app, true);
}
public bool Intersects(Range range)
{
bool retValue = this.Intersects(range.XlRange);
return retValue;
}
public Range GetOffset(int rows, int columns)
{
XL.Range xlOffsetRng = this.XlRange.get_Offset(rows, columns);
Range retValue = new Range(xlOffsetRng);
return retValue;
}
public Range GetIntersection(Range range)
{
XL.Range intersection = this.GetIntersection(range.XlRange);
Range retValue = new Range(intersection);
return retValue;
}
public Range GetNamedRange(string name)
{
XL.Range xlRng = this.GetXlRangeByName(name);
Range retValue = new Range(xlRng);
return retValue;
}
public void SetNamedRange(string name, Range range)
{
this.XlWorkbook.Names.Add(name, range.XlRange);
}
public Range GetEntireWorksheetRange()
{
XL.Range entireWsRng = this.XlWorksheet.Cells.EntireRow.EntireColumn;
Range retValue = new Range(entireWsRng);
return retValue;
}
public Range GetRange(string address)
{
Range retValue = new Range(this, address);
return retValue;
}
public Range GetA1Range()
{
XL.Range rng = this.XlWorksheet.Cells[1, 1];
Range retValue = new Range(rng);
return retValue;
}
public Range GetUsedRange()
{
XL.Range usedRng = this.XlWorksheet.UsedRange;
Range retValue = new Range(usedRng);
return retValue;
}
public Range GetRange(Range upperLeft, Range lowerRight)
{
XL.Range xlRng = this.XlWorksheet.Range[upperLeft.XlRange, lowerRight.XlRange];
Range retValue = new Range(xlRng);
return retValue;
}
public Range GetRange(Range upperLeft, int numberOfRows, int numberOfColumns)
{
XL.Range xlEndRng = this.XlWorksheet.Cells[upperLeft.Row + numberOfRows - 1, upperLeft.Column + numberOfColumns - 1];
XL.Range xlRng = this.XlWorksheet.Range[upperLeft.XlRange, xlEndRng];
Range retValue = new Range(xlRng);
return retValue;
}
public Range GetRange(Range upperLeft, RangeSize size)
{
Range retValue = this.GetRange(upperLeft, size.Rows, size.Columns);
return retValue;
}