IPrxReport.ParseCell

Syntax

ParseCell(Address: String): IPrxRange;

Parameters

Address - full address of the cell.

Description

The ParseCell method returns the object containing parsed address of the cell.

Example

Sub Main;
Var
    MB: IMetabase;
    Report: IPrxReport;
    PrxRange: IPrxRange;
    Sheet: IPrxSheet;
    Range: ITabRange;
    v: Variant;
Begin
    MB := MetabaseClass.Active;
    Report := MB.ItemById("Report").Bind As IPrxReport;
    PrxRange := Report.ParseCell("Sheet1!B4");
    Sheet := PrxRange.Sheet;
    Range := PrxRange.Range;
    v := Range.Value;
End Sub Main;

After executing the example the Sheet variable contains the sheet named Sheet1 and the v variable contains the value of the B4 cell located on this sheet. The identifier of the regular report - Report.