TExcelFile.DeleteSheet Method

Overloads

TExcelFile.DeleteSheet(Integer)

Deletes the active sheet and aSheetCount-1 sheets more to the right. It will change all formula references to that sheet to invalid, and might change the active sheet so it remains valid.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.DeleteSheet(const aSheetCount: Integer); overload;

Parameters

<-> Parameter Type Description
const aSheetCount Integer The number of sheets to delete from the active sheet.

See also

TExcelFile.DeleteSheet(string)

Deletes the sheet with name aSheetName. It will change all formula references to that sheet to invalid, and might change the active sheet so it remains valid.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.DeleteSheet(const aSheetName: string); overload;

Parameters

<-> Parameter Type Description
const aSheetName string The name of the sheet to delete.

See also

TExcelFile.DeleteSheet(Integer, Integer)

Deletes sheet aSheet and aSheetCount-1 sheets more to the right. It will change all formula references to that sheet to invalid, and might change the active sheet so it remains valid.

Syntax

Unit: FlexCel.Core

procedure TExcelFile.DeleteSheet(const aSheet: Integer; const aSheetCount: Integer); overload; virtual; abstract;

Parameters

<-> Parameter Type Description
const aSheet Integer First sheet to delete (1-based).
const aSheetCount Integer The number of sheets to delete.

See also