Table of Contents

TMSFNCGridBridgeCore Namespace

Classes

Name Description
TLocationOptions Defines which rows and columns to export from the grid and into which rows and columns in Excel.

Records

Name Description
TExportProgress​Event​Args Arguments passed in the ExportProgress event.

Enumerations

Name Description
TExportDataType Defines how a cell will be exported to Excel.
THtmlExportMode Defines how the grid will be exported to html.
THyperlinkExportMode Determines how (and if) hyperlinks in the grid will be exported to Excel.
TInsertInSheet How the cells will be inserted when exporting to an existing file.

Types

Name Description
TExportProgressEvent Event that gets called when the data is being imported/​exported.​

Constants

Name Description
CellOfs Offset for the cells. Internal use.
ErrNoAdvStrGrid No TAdvStringGrid is attached to the component.
Clear Clears everything on the sheet before exporting the grid.
OverwriteCells Overwrites existing cells, but does not clear any existing information on the sheet.
InsertRows Inserts the grid inside the existing sheet, moving all the other rows down.
InsertCols Inserts the grid inside the existing sheet, moving all the other columns to the right.
InsertRowsExcept​First​AndSecond Inserts the grid inside the existing sheet, moving all the other rows down (Grid.RowCount - 2) rows. The first two rows will be overwritten.
This can be used to export for example inside of a chart.
InsertColsExcept​First​AndSecond Inserts the grid inside the existing sheet, moving all the other columns right (Grid.ColCount - 2) columns. The first two columns will be overwritten. This can be used to export for example inside of a chart.
Value The cell will be converted to what it represents. For example, the string "1/1/2000" will be entered as a date.
Text Whatever you have in the grid, will be exported as a string to Excel.
Numeric format will be preserved, but the Excel cells will contain strings, never numbers. Those strings can't be used in formulas, for example the sum of a range containing strings with numbers will always be 0.
Html The cell contains HTML formatted text, and will be entered in Excel as rich text.
Formula The cell contains a formula.
SingleSheet Only the current sheet in a workbook will be exported.
AllSheetsAsTabs All sheets in the workbook will be exported, with tabs at the top.
AllSheetsAsSingle​File All sheets will be exported, one after the other in the same filesheet.
None Hyperlinks won't be exported to Excel.
FirstLink The first link in the cell will be exported. Note that Excel doesn't allow more than 1 link per cell.