TInsertInSheet Enumeration

Specifies how the DataGrid content is inserted into an existing worksheet during export.

API unit family: TMSFNCDataGridExcelIO

Members

Name	Description
InsertInSheet_Clear	Clears everything on the sheet before exporting the DataGrid.
InsertInSheet_OverwriteCells	Overwrites existing cells but does not clear any other content on the sheet.
InsertInSheet_InsertRows	Inserts the DataGrid by shifting all existing rows downward to make room.
InsertInSheet_InsertCols	Inserts the DataGrid by shifting all existing columns to the right to make room.
InsertInSheet_InsertRowsExceptFirstAndSecond	Shifts rows down by RowCount - 2; the first two rows are overwritten. Useful for inserting inside a chart area.
InsertInSheet_InsertColsExceptFirstAndSecond	Shifts columns right by ColCount - 2; the first two columns are overwritten. Useful for inserting inside a chart area.