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

See also
Exports
Localization

Created with the Personal Edition of HelpNDoc: Free EPub and documentation generator