HoleTable.Export Method

Parent Object: HoleTable

Description

Method that saves the custom table to an external file.

Syntax

HoleTable.Export( FileName As String, FileFormat As FileFormatEnum, [Options] As Variant )

Parameters

Name Type Description
FileName String Input string that specifies the file name to export the table to. The valid file extension for this file are .csv and .txt.
FileFormat FileFormatEnum Input FileFormatEnum to specify the file format to export. Valid values for export hole tables are:kTextFileCommaDelimitedFormat, kTextFileTabDelimitedFormat, kUnicodeTextFileCommaDelimitedFormat and kUnicodeTextFileTabDelimitedFormat.
Options Variant Optional input NameValueMap object that specifies additional options for export. See Remarks for valid inputs:

This is an optional argument whose default value is null.

Remarks

Valid inputs for Options parameter:
NameValue typeValid for Export formats
TableNameStringkMicrosoftExcel, kMicrosoftAccess
ExportedColumnsString containing semicolon separated column titlesAll
IncludeTitleBooleankMicrosoftExcel, kTextFileCommaDelimited, kTextFileTabDelimited, kUnicodeTextFileCommaDelimited, kUnicodeTextFileTabDelimited
StartingCellStringkMicrosoftExcel
TemplateStringkMicrosoftExcel
AutoFitColumnWidthBooleankMicrosoftExcel

Version

Introduced in version 2009