fcMTblExcelExpParams

This class is used to define the parameters for MTblExportToExcelEx.

Instance Variables
Language
Number: Language. Specify MTE_LNG_GERMAN, MTE_LNG_ENGLISH or the ID of a registered custom language. The language refers to the status dialog and messages.

ExcelStartCell
String: Cell in Excel that shall be the starting point. You can also specify STRING_Null for no start cell. If the flag MTE_EXCEL_CURRENT_POS is set, this parameter is ignored.

ExcelSaveAsFile
String: If set, the workbook is saved as the specified file when the data export is finished.

ExcelTemplateFile
String: If set, the specified file is opened before the data export begins.

ExcelSheetName
String: If set, the worksheet name is set with the specified name.

ExcelFlags
Number: Optional Excel flags:

MTE_EXCEL_RUNNING_INSTANCE	Exports to a running instance.
MTE_EXCEL_NEW_INSTANCE	Exports to a new instance.
MTE_EXCEL_HIDE_INSTANCE	Hides the instance while exporting. When the export is done, the instance is shown again.
MTE_EXCEL_CLOSE_INSTANCE	Closes the instance when the export is done.
MTE_EXCEL_NEW_WORKBOOK	Exports to a new workbook. This flag is ignored when exporting to a new instance.
MTE_EXCEL_CLOSE_WORKBOOK	Closes the workbook when the export is done.
MTE_EXCEL_NEW_WORKSHEET	Exports to a new worksheet. This flag is ignored when exporting to a new instance.
MTE_EXCEL_CURRENT_POS	Uses the active cell in Excel as the starting point. If you don't specify this flag, the starting point is cell "A1".
MTE_EXCEL_STRING_COLS_AS_TEXT	The cell's data type in Excel is set to "Standard" before inserting any text in order to let Excel determine the data type. However, in some cases this has the unwanted effect that Excel interprets a text as a date or something similar, e.g. "1/2" is interpreted as "01-Feb". When you set this flag, the data type of the cells in Excel which belong to a string column in the table are set to "Text" in order to "tell" Excel to leave them unchanged.
MTE_EXCEL_NULLS_AS_SPACE	Exports null values ( empty cells ) as a space character
MTE_EXCEL_NO_CLIPBOARD	The clipboard isn't used to set cell data in Excel. Instead, the cell data is set directly by "Range.SetFormulaLocal". Setting the cell data directly is somewhat slower, but it avoids that - as some users reported - sometimes "Worksheet.PasteSpecial" throws an exception.
MTE_EXCEL_NO_AUTO_FIT_COL	The Excel method "AutoFit" isn't performed on columns
MTE_EXCEL_NO_AUTO_FIT_ROW	The Excel method "AutoFit" isn't performed on rows

ExpFlags
Number: Optional export flags:

MTE_COL_HEADERS	Exports column headers.
MTE_COLORS	Exports text and background colors.
MTE_FONTS	Exports fonts and font enhancements.
MTE_GRID	Exports a grid according to the table's row and column lines.
MTE_SPLIT_ROWS	Exports also split rows ( if any )
MTE_SHOW_STATUS	Displays a status dialog with a "Cancel" button.

RowFlagsOn
Number: The flags a row should have to be exported.RowFlagsOff
Number: The flags a row should not have to be exported.ColFlagsOn
Number: The flags a column should have to be exported.ColFlagsOff
Number: The flags a column should not have to be exported.

Functions
Assign