TExcelFile.DeleteSheet Method
Overloads
- TExcelFile.DeleteSheet(Integer)
- TExcelFile.DeleteSheet(string)
- TExcelFile.DeleteSheet(Integer, Integer)
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. |