FindRowMember Property

Microsoft Office Web Components Object Model

Show All

FindRowMember Property

       

Finds a row member, given a reference to the member. Returns a PivotRowMember object.

expression.FindRowMember(Path, Format)

expression   Required. An expression that returns a PivotRowMember object.

Path  Required String. A variable or string that contains a reference to the member to find.

Format  Required PivotMemberFindFormatEnum. Indicates the format used for the Path argument.

PivotMemberFindFormatEnum can be one of these PivotMemberFindFormatEnum constants.
plFindFormatMember Member reference is a named path. For example, "USA\Oregon\Portland".
plFindFormatPathHex  Member reference is a path of hexadecimal indexes.
plFindFormatPathInt  Member reference is a path of indexes. For example, "1\0\5\1".
plFindFormatPathName  Member reference is a unique name or can be a name if unambiguous. For example, "[USA].[Oregon].[Portland]".

Remarks

If the requested member is not found, a PivotRowMember object with the IsValid property set to False is returned. This allows you to refer to a member that might later be added to the schema.