Export Options String

Since the Export Options dialog is not displayed when the program is driven from an automation script, an options string can be specified in the script. The string consists of comma-separated parameters which specify the behavior of the various export options. A typical example would be:

"Delimiter=comma;

This would set the delimiter character to a comma and the text qualifier character to the single-quote mark ( ‘ ).

Option	Action	Default	Description
DecimalSymbol	period = period comma = comma	period	The character to use as the decimal symbol. This option is only available with .TXT files.
Delimiter	tab = tab comma = comma semicolon = semicolon space = space other = enter the delimiter character	comma	Character that separates data cell values. Only one delimiter character should be specified on export. For example, if you want to export a data file using a percent signs to delimit data, add a "Delimiter=%" to the export options string.
ExportCodePage	String	""	The name of the ANSI code page to use when exporting Unicode data.
ExportEncodingMethod	0 = unencoded ANSI translated using codepage 1 = Windows Unicode (with signature) 2= encoded UTF-8 (with signature)	0	The text encoding method. 0 is normal text. 1 and 2 are Unicode text.
FileFormat	BIFF8 = Excel-97 BIFF5 = Excel-95	BIFF8	Determines the file format when saving an XLS file.
TextQualifier	doublequote = doublequote (") singlequote = singlequote (') none = none other = enter the text qualifier	doublequote	Specifies the character that surrounds cells containing text. Only one text qualifier character should be specified on export. For example, if you want to export a data file using a single quote mark as the text qualifier, add “TextQualifier=singlequote” to the export options string.

Export Options String

See Also