Table of Contents

TExcelFile.DeleteRange Method

Overloads

TExcelFile.DeleteRange(TXlsCellRange, TFlxInsertMode)

Deletes a range of cells, and moves all cells below up or all cells to the right left, depending on the insert mode.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.DeleteRange(const cellRange: TXlsCellRange; const insertMode: TFlxInsertMode); overload; virtual; abstract;

Parameters

<-> Parameter Type Description
const cellRange TXlsCellRange Range of cells to delete.
const insertMode TFlxInsertMode Mode of deletion. Note that Row and Col are equivalent to ShiftRight and ShiftDown with a cell range of full rows or cols respectively.

See also

TExcelFile.DeleteRange(Integer, Integer, TXlsCellRange, TFlxInsertMode)

Deletes a range of cells, and moves all cells below up or all cells to the right left, depending on the insert mode.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.DeleteRange(const sheet1: Integer; const sheet2: Integer; const cellRange: TXlsCellRange; const insertMode: TFlxInsertMode); overload;

Parameters

<-> Parameter Type Description
const sheet1 Integer First sheet where to delete cells.
const sheet2 Integer Last sheet where to delete cells.
const cellRange TXlsCellRange Range of cells to delete.
const insertMode TFlxInsertMode Mode of deletion. Note that Row and Col are equivalent to ShiftRight and ShiftDown with a cell range of full rows or cols respectively.

See also

TExcelFile.DeleteRange(Integer, Integer, TXlsCellRange, TFlxInsertMode, Boolean)

Deletes a range of cells, and moves all cells below up or all cells to the right left, depending on the insert mode.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.DeleteRange(const sheet1: Integer; const sheet2: Integer; const cellRange: TXlsCellRange; const insertMode: TFlxInsertMode; const removeFormats: Boolean); overload; virtual; abstract;

Parameters

<-> Parameter Type Description
const sheet1 Integer First sheet where to delete cells.
const sheet2 Integer Last sheet where to delete cells.
const cellRange TXlsCellRange Range of cells to delete.
const insertMode TFlxInsertMode Mode of deletion. Note that Row and Col are equivalent to ShiftRight and ShiftDown with a cell range of full rows or cols respectively.
const removeFormats Boolean If true, both formatting and data will be removed from the range, when clearing a range.
This parameter has no effect if insertmode isn't one of the "none" options, because if it isn't the full range will move up or left.

See also