Reference>IXLSRange>Delete :: Delphi + Excel

Deletes a cell or a range of cells from the worksheet.

Syntax

function Delete(Shift: OleVariant): OleVariant;

Shift

OleVariant. Specifies how to shift cells to replace deleted cells. Can be one of the following XlDeleteShiftDirection constants: xlShiftToLeft or xlShiftUp.

Example

This example deletes row 3 from sheet one.

Workbook.Sheets[1].Range['A3', 'A3'].EntireRow.Delete(xlShiftUp);

NativeExcel suite v2.x

Delete method

Syntax

Example