If you are familiar with the contents of your database, you can use the Smart View functions described below to perform operations on specific data in Excel cells.
HsGetValue: Retrieves data from a data source.
HsSetValue: Sends values to the data source.
HsCurrency: Retrieves the entity currency for the selected members.
HsDescription: Displays the description for the default member.
HsLabel: Displays the label for the default member.
HsGetText: Retrieves cell text from the data source.
HsSetText: Sends cell text to the data source.
HsGetVariable: Retrieves the associated value for a substitution variable.
HsGetSheetInfo: Retrieves detailed information about the current worksheet.