ExcelFile.DeleteRange Method
Overloads
- ExcelFile.DeleteRange(TXlsCellRange, TFlxInsertMode)
- ExcelFile.DeleteRange(Int32, Int32, TXlsCellRange, TFlxInsertMode)
- ExcelFile.DeleteRange(Int32, Int32, TXlsCellRange, TFlxInsertMode, Boolean)
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. |