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