TInsertInSheet Enumeration

Specifies how the grid content is placed in an existing worksheet during export.

API unit family: TMSFNCDataGridExcelIO

Remarks

Only applies when the target file already exists and contains a sheet whose name matches the SheetName passed to XLSExport (case-insensitive). Otherwise the grid is written to a new sheet or new file and this value is ignored.

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.