ExcelFile.DeleteRange Method

Overloads

ExcelFile.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

Namespace: FlexCel.Core

public abstract void DeleteRange(TXlsCellRange cellRange, TFlxInsertMode insertMode)

Parameters

<-> Parameter Type Description
cellRange TXlsCellRange Range of cells to delete.
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

ExcelFile.DeleteRange(Int32, Int32, 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

Namespace: FlexCel.Core

public void DeleteRange(Int32 sheet1, Int32 sheet2, TXlsCellRange cellRange, TFlxInsertMode insertMode)

Parameters

<-> Parameter Type Description
sheet1 Int32 First sheet where to delete cells.
sheet2 Int32 Last sheet where to delete cells.
cellRange TXlsCellRange Range of cells to delete.
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

ExcelFile.DeleteRange(Int32, Int32, 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

Namespace: FlexCel.Core

public abstract void DeleteRange(Int32 sheet1, Int32 sheet2, TXlsCellRange cellRange, TFlxInsertMode insertMode, Boolean removeFormats)

Parameters

<-> Parameter Type Description
sheet1 Int32 First sheet where to delete cells.
sheet2 Int32 Last sheet where to delete cells.
cellRange TXlsCellRange Range of cells to delete.
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.
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