DBTable.FilterSparseDataEx

Filter sparse data.

Syntax Parameters Return Value
Function DBTable.FilterSparseDataEx( _
    Optional Variables As Variant, _
    Optional OutputVariables As Variant, _
    Optional MaxPercentMDInVariables As Double = 10.0, _
    Optional MaxPercentMDInCases As Double = 10.0, _
    Optional UseSpreadsheetSelCond As Boolean = True, _
    Optional selectionIncludeExpression As String, _
    Optional selectionIncludeList As String, _
    Optional selectionExcludeExpression As String, _
    Optional selectionExcludeList As String, _
    Optional CopyFormatting As Boolean = False, _
    Optional CreateSpreadsheet As Boolean = True) As Spreadsheet
  • Variables [in, optional]

    Type: Variant

  • OutputVariables [in, optional]

    Type: Variant

  • MaxPercentMDInVariables [in, optional]

    Type: Double

    Default value: 10.0

  • MaxPercentMDInCases [in, optional]

    Type: Double

    Default value: 10.0

  • UseSpreadsheetSelCond [in, optional]

    Type: Boolean

    Default value: True

  • selectionIncludeExpression [in, optional]

    Type: String

  • selectionIncludeList [in, optional]

    Type: String

  • selectionExcludeExpression [in, optional]

    Type: String

  • selectionExcludeList [in, optional]

    Type: String

  • CopyFormatting [in, optional]

    Type: Boolean

    Default value: False

  • CreateSpreadsheet [in, optional]

    Type: Boolean

    Default value: True

Spreadsheet