IPrxRange.Sheet

Syntax

Sheet: IPrxSheet;

Description

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

Example

Sub Main;

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

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.

See also:

IPrxRange