In This Topic ▼
LEADWorkbook Class Members
Summary
The following tables list the members exposed by LEADWorkbook.
Public Methods
| Name | Description | |
|---|---|---|
 |
CreateCellStyle | Creates and returns a new CellStyle object, allowing for the customization of cell appearance within the workbook. |
|
CreateFont | Creates a new Font object with specified attributes, allowing for detailed customization of text appearance in the workbook.Provides the ability to define fonts with specific names, sizes, styles, and colors, which can then be applied to cell styles. |
|
CreateHyperlink | Creates a new Hyperlink object with a specified address and tooltip, enabling the addition of interactive links to the Excel workbook. Allows for embedding clickable hyperlinks within spreadsheet cells to direct users to external resources, other documents, or locations within the same workbook. |
|
CreateSheet | Creates and adds a new sheet to the Excel workbook with the specified name.Allows for the dynamic expansion of the workbook by adding additional sheets. |
|
ExportWorkbook | Exports the current state of the workbook to a file. |
|
GetSheet | Retrieves a sheet from the Excel workbook based on the specified name. |
|
GetSheetAt | Retrieves a sheet from the Excel workbook by its index. Provides access to a sheet based on its position within the workbook. |
|
IsSheetHidden | Determines whether a specified sheet within the Excel workbook is hidden. This method checks the visibility state of a sheet by its name. |
|
RemoveSheet | Removes a sheet from the Excel workbook by name. Allows for the deletion of a specified sheet within the workbook, facilitating dynamic management of the workbook's content and structure. |
|
RemoveSheetAt | Removes a sheet from the Excel workbook by its index. |
|
SetSheetHidden | Modifies the visibility of a specified sheet within the Excel workbook. Allows for programmatically hiding or showing sheets. |
Public Properties
| Name | Description | |
|---|---|---|
 |
ActiveSheetIndex | Gets the current active sheet index. |
|
Document | Provides access to the LEADDocument object associated with the current workbook. |
|
SheetCount | Gets the number of sheets currently in the Excel workbook. |
