Report > Report Assembly Interfaces > IPrxRange > IPrxRange.Sheet

IPrxRange.Sheet

Syntax

Description

The Sheet property returns an object containing a regular report sheet.

Example

Sub UserProc;
Var
    MB: IMetabase;
    Report: IPrxReport;
    Range: IPrxRange;
    Sheet: IPrxSheet;
    i: Integer;
Begin
    MB := MetabaseClass.Active;
    Report := MB.ItemById("Report").Bind As IPrxReport;
    Range := Report.ParseCell("Sheet2!B4");
    Sheet := Range.Sheet;
    i := Sheet.Index;
End Sub UserProc;

After executing the example the "i" variable contains index of the sheet obtained as the result of parsing the absolute address of the Sheet2!B4 cell.