Search Results for

    Show / Hide Table of Contents

    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

    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

    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

    • TExcelFile
    In This Article
    Back to top FlexCel Studio for VCL and FireMonkey v7.8.0
    © 2002 - 2020 tmssoftware.com