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