In This Topic ▼

Sheet Class Methods

Summary

For a list of all members of this type, see Sheet members

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.

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.