TXlsFile.DeleteRange Method
Overloads
TXlsFile.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.XlsAdapter
procedure TXlsFile.DeleteRange(const cellRange: TXlsCellRange; const insertMode: TFlxInsertMode); overload; override;
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
TXlsFile.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.XlsAdapter
procedure TXlsFile.DeleteRange(const sheet1: Integer; const sheet2: Integer; const cellRange: TXlsCellRange; const insertMode: TFlxInsertMode; const removeFormats: Boolean); overload; override;
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