TInsertInSheet Enumeration
How the cells will be inserted when exporting to an existing file.
Syntax
Unit: UAdvGridExcelExport
Members
| Name | Value | Description |
|---|---|---|
| Clear | 0 | Clears everything on the sheet before exporting the grid. |
| OverwriteCells | 1 | Overwrites existing cells, but does not clear any existing information on the sheet. |
| InsertRows | 2 | Inserts the grid inside the existing sheet, moving all the other rows down. |
| InsertCols | 3 | Inserts the grid inside the existing sheet, moving all the other columns to the right. |
| InsertRowsExceptFirstAndSecond | 4 | 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 | 5 | 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. |