Application.ImportXLSAsWorkbookEx

This function imports a set of Excel worksheets into a Statistica Workbook (with extended options).

Syntax Parameters Return Value 
Function Application.ImportXLSAsWorkbookEx( _
    fileName As String, _
    Optional bCaseNamesFromFirstColumn As Boolean = False, _
    Optional bVariableNamesFromFirstRow As Boolean = False, _
    Optional bIncludeFormatting As Boolean = False, _
    Optional Action As ImportRecodeType = scImportTextToTV, _
    Optional ArrTextVars As Variant = 0) As Workbook
  • fileName [in]

Type: String

  • bCaseNamesFromFirstColumn [in,optional]

Type: Boolean

Default value: False

  • bVariableNamesFromFirstRow [in,optional]

Type: Boolean

Default value: False

  • bIncludeFormatting [in,optional]

Type: Boolean

Default value: False

  • Action [in,optional]

Type: ImportRecodeType

Default value: scImportTextToTV

  • ArrTextVars [in,optional]

Type: Variant

Default value: 0

ProgressBar