HypIsSmartViewContentPresent
Cloud data provider types: Oracle Analytics Cloud - Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management
Description
HypIsSmartViewContentPresent() determines whether the sheet contains Oracle Smart View for Office content.
Syntax
HypIsSmartViewContentPresent(vtSheetName, vtTypeOfContentsInSheet])
ByVal vtSheetName As Variant
ByRef vtTypeOfContentsInSheet
Parameters
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null
or Empty
, the active worksheet is used.
vtTypeOfContentsInSheet: Output parameter; returns the type of content on the worksheet. Possible values are in the enum as follows;.
Enum TYPE_OF_CONTENTS_IN_SHEET
EMPTY_SHEET
ADHOC_SHEET
FORM_SHEET
INTERACTIVE_REPORT_SHEET
End Enum
Return Value
Returns True if the worksheet contains Smart View content; otherwise, returns False.
Example
Public Declare Function HypIsSmartViewContentPresent Lib "HsAddin" (ByVal vtSheetName As Variant, ByRef vtTypeOfContentsInSheet As TYPE_OF_CONTENTS_IN_SHEET) As Boolean
Sub Example_HypIsSmartViewContentPresent()
Dim Ret As Boolean
Dim vtTypeOfContentsInSheet As TYPE_OF_CONTENTS_IN_SHEET
Dim SheetName As String
Dim SheetDisp As Worksheet
SheetName = Empty
Set SheetDisp = Worksheets("Sheet1")
Ret = HypIsSmartViewContentPresent (Empty, ContentType)
End Sub