Sheet Class Members

Summary

The following tables list the members exposed by Sheet.

Public Methods

Name Description
Public Method CreateColumns Creates new columns and inserts them at the specified index within the sheet.
Public Method CreateRow Creates a new row and inserts it at the specified index within the sheet.
Public Method CreateRows Creates new rows and inserts them at the specified index within the sheet.
Public Method GetColumnWidthInPixel Retrieves the width of a specified column within the sheet.
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 the visibility status of an individual column.
Public Method IsRowHidden Determines the visibility status of an individual row.
Public Method RemoveColumns Removes a specific number of columns from a sheet, starting from a given index.
Public Method RemoveRows Removes a specific number of rows from a sheet, starting from a given index.
Public Method SetCellRangeBorder Sets the border style for a specified border of the cell range.
Public Method SetColumnHidden Changes the visibility status of an individual column.
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 Changes the visibility status of an individual row.
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 ColumnsCount Gets the number of columns in a sheet.
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 identifies 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 sheet name.
Public Property RowsCount Gets the number of rows in a sheet.

See Also

Sheet Class

Leadtools.Document.SheetEditor Namespace

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

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