←Select platform

Sheet Class Members

Summary

The following tables list the members exposed by Sheet.

Public Methods

Name Description
Public Method CreateColumns Creates a specified number of new columns starting from a given index within the sheet.
Public Method CreateRow Creates a new row at the specified index within the sheet.
Public Method CreateRows Creates a specified number of new rows starting from a given index within the sheet.
Public Method GetColumnWidthInPixel Retrieves the width of a specified column within the sheet.
Public Method GetEnumerator Overrides Objects.GetEnumerator.
Public Method GetRowAt Retrieves the row at the specified index within the sheet.
Public Method GetRowHeightInPixel Retrieves the height of a specified row within the sheet.
Public Method IsColumnHidden Determines whether a specified column within the sheet is hidden. Allows for checking the visibility status of individual columns.
Public Method IsRowHidden Determines whether a specified row within the sheet is hidden.
Public Method RemoveColumns Removes a specified number of columns starting from a given index within the sheet.
Public Method RemoveRows Removes a specified number of rows starting from a given index within the sheet.
Public Method SetColumnHidden Hides or reveals a specified column within the sheet.
Public Method SetColumnWidthInPixel Adjusts the width of a specified column within the sheet, measured in pixels.
Public Method SetRowHeightInPixel Adjusts the height of a specified row within the sheet, measured in pixels.
Public Method SetRowHidden Hides or reveals a specified row within the sheet.
Public Method SortCellRange Sorts a specified range of cells within the sheet according to a set of defined sorting options.

Public Properties

Name Description
Public Property DefaultColumnWidth Gets or sets the default width for columns within the sheet. This property specifies the standard width applied to columns in the absence of specific column width settings.
Public Property DefaultRowHeight Gets or sets the default height for rows within the sheet. This property defines the standard height applied to rows in the absence of specific row height settings.
Public Property FirstRowIndex Gets the index of the first non-empty row within the sheet.This property is instrumental in identifying the starting point of data or content within a sheet, enabling targeted operations on rows that contain information.
Public Property Images Provides access to the SheetImages collection associated with the sheet.
Public Property LastRowIndex Gets the index of the last non-empty row within the sheet.
Public Property MergedRegions Provides access to the MergedCellRegions collection associated with the sheet.This property enables the management of merged cell regions within the sheet, offering functionalities to add, remove, or access merged regions.
Public Property Name Gets or sets the name of the sheet. This property allows for the identification and customization of the sheet name within a workbook, facilitating easy navigation and reference among multiple sheets.

See Also

Sheet Class

Leadtools.Document.LEADOffice.Sheet Namespace

Help Version 23.0.2024.4.15
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2024 LEAD Technologies, Inc. All Rights Reserved.

Leadtools.Document.LEADOffice Assembly
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2023 LEAD Technologies, Inc. All Rights Reserved.