DBTable.ExportXLSEx

Export a spreadsheet to a XLS file with formatting option.

Syntax Parameters Return Value
Function DBTable.ExportXLSEx( _
    FileName As String, _
    Optional FirstRow As Long = 1, _
    Optional LastRow As Long = 0, _
    Optional FirstColumn As Long = 1, _
    Optional LastColumn As Long = 0, _
    Optional UseTextLabels As Boolean = True, _
    Optional CaseNamesToFirstColumn As Boolean = False, _
    Optional VariableNamesToFirstRow As Boolean = False, _
    Optional VariableLongNames As Boolean = False, _
    Optional ExportFormatting As Boolean = False, _
    Optional OverWriteFile As Boolean = True) As Boolean
  • FileName [in]

    Type: String

  • FirstRow [in, optional]

    Type: Long

    Default value: 1

  • LastRow [in, optional]

    Type: Long

    Default value: 0

  • FirstColumn [in, optional]

    Type: Long

    Default value: 1

  • LastColumn [in, optional]

    Type: Long

    Default value: 0

  • UseTextLabels [in, optional]

    Type: Boolean

    Default value: True

  • CaseNamesToFirstColumn [in, optional]

    Type: Boolean

    Default value: False

  • VariableNamesToFirstRow [in, optional]

    Type: Boolean

    Default value: False

  • VariableLongNames [in, optional]

    Type: Boolean

    Default value: False

  • ExportFormatting [in, optional]

    Type: Boolean

    Default value: False

  • OverWriteFile [in, optional]

    Type: Boolean

    Default value: True

Boolean