Library.ImportXLSAsSpreadsheetEx

This function imports an Excel worksheet into a Statistica Spreadsheet (with extended options).

Syntax Parameters Return Value 
Function Library.ImportXLSAsSpreadsheetEx( _
    fileName As String, _
    sheetNumber As Integer, _
    Optional TextVars As Variant = 0, _
    Optional TextLengths As Variant = 0, _
    Optional bCaseNamesFromFirstColumn As Boolean = False, _
    Optional bVariableNamesFromFirstRow As Boolean = False, _
    Optional bIncludeFormatting As Boolean = False, _
    Optional Action As ImportRecodeType = scImportTextToTV, _
    Optional firstRow As Long = 1, _
    Optional lastRow As Long = -1, _
    Optional firstColumn As Long = 1, _
    Optional lastColumn As Long = -1) As Spreadsheet
  • fileName [in]

Type: String

  • sheetNumber [in]

Type: Integer

  • TextVars [in,optional]

Type: Variant

Default value: 0

  • TextLengths [in,optional]

Type: Variant

Default value: 0

  • 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

  • firstRow [in,optional]

Type: Long

Default value: 1

  • lastRow [in,optional]

Type: Long

Default value: -1

  • firstColumn [in,optional]

Type: Long

Default value: 1

  • lastColumn [in,optional]

Type: Long

Default value: -1

Spreadsheet