FMX.TMSGridExcelExport.TInsertInSheet Enumeration

How the cells will be inserted when exporting to an existing file.

Pascal

TInsertInSheet = (
  Clear,
  OverwriteCells,
  InsertRows,
  InsertCols,
  InsertRowsExceptFirstAndSecond,
  InsertColsExceptFirstAndSecond
);

FMX.TMSGridExcelExport

Members	Description
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.
InsertRowsExceptFirstAndSecond	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.
InsertColsExceptFirstAndSecond	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.

What do you think about this topic? Send feedback!