Function Descriptions

Oracle Smart View for Office provides the following functions:

HsGetValue: Retrieves data from a data source for a given Point of View.

HsSetValue: Sends values to the data source for a given Point of View.

HsGetSheetInfo: Retrieves detailed information about the current worksheet.

HsCurrency: Retrieves the entity currency for the selected members.

HsDescription: Displays the description for the default Point of View member.

HsLabel: Displays the label for the default Point of View member.

HsGetText: Retrieves cell text from the data source.

HsSetText: Sends cell text to the data source.

HsGetVariable: Retrieves the value for a substitution variable.

Smart View provides the following functions. Click a function name below to access description, syntax, and examples.

HsGetValue: Retrieves data from a data source for a given Point of View.

HsSetValue: Sends values to the data source for a given Point of View.

HsGetSheetInfo: Retrieves detailed information about the current worksheet.

HsCurrency: Retrieves the entity currency for the selected members.

HsDescription: Displays the description for the default Point of View member.

HsLabel: Displays the label for the default Point of View member.

HsGetText: Retrieves cell text from the data source.

HsSetText: Sends cell text to the data source.

HsGetVariable: Retrieves the value for a substitution variable.