HsGetSheetInfo

Data sources: all

HsGetSheetInfo retrieves detailed information about the current worksheet, as described in Table 12.

Table 12. HsGetSheetInfo Details

Numerical EquivalentString EquivalentSheet Information
1ConnectedConnection status
2Sheet TypeAd hoc or form
3ServerThe server to which the sheet is connected
4ApplicationThe application to which the sheet is connected
5CubeThe cube to which the sheet is connected
6URLThe URL to which the sheet is connected
7ProviderThe data source type to which the sheet is connected
8Provider URLThe provider to which the sheet is connected; applicable for Oracle Hyperion Provider Services connections
9Friendly NameThe data source connection name
10Alias TableThe current alias table
11UserThe user name
12DescriptionThe connection description

Syntax

HsGetSheetInfo("<string equivalent>")
HsGetSheetInfo("<numerical equivalent>")

Example

In this example, HsGetSheetInfo tells you whether the worksheet contains an ad hoc grid or a form.

HsGetSheetInfo("Sheet Type")