HotXLS Docs

ActiveSheet property

Yields an object that represents the active sheet in the specified Workbook. Yields Nothing if no sheet is active. Read-only. Employ ActiveSheetIndex or Activate to choose the active sheet, and employ FirstSheet to choose the first visible tab in the workbook tab bar

Syntax

property ActiveSheet: TXLSWorksheet;

Example

This example sets the name of the active sheet

Workbook.ActiveSheet.Name := 'NewName';