Application.ImportXLSAsWorkbook

This function imports a set of Excel worksheets into a Statistica Workbook.

Syntax Parameters Return Value 
Function Application.ImportXLSAsWorkbook( _
    fileName As String, _
    Optional bCaseNamesFromFirstColumn As Boolean = False, _
    Optional bVariableNamesFromFirstRow As Boolean = False, _
    Optional bIncludeFormatting As Boolean = False) As Workbook
  • fileName [in]

The fully-qualified pathway of the Excel file.

Type: String

  • bCaseNamesFromFirstColumn [in,optional]

Whether or not to import the first column as the case names. This parameter defaults to False.

Type: Boolean

Default value: False

  • bVariableNamesFromFirstRow [in,optional]

Whether or not to import the first row as the variable names. This parameter defaults to False.

Type: Boolean

Default value: False

  • bIncludeFormatting [in,optional]

Whether or not to import cell formatting. This parameter defaults to False.

Type: Boolean

Default value: False

Workbook