Click or drag to resize

ExcelWorksheet Class

Represents an Excel worksheet object.
Inheritance Hierarchy
SystemObject
  SautinSoft.ExcelExcelWorksheet

Namespace: SautinSoft.Excel
Assembly: SautinSoft.Excel (in SautinSoft.Excel.dll) Version: 2025.2.6
Syntax
Copy
public sealed class ExcelWorksheet

The ExcelWorksheet type exposes the following members.

Properties
 NameDescription
Public propertyCells Gets CellRange with all the cells in the worksheet.
Public propertyColumns Gets collection of all columns in the worksheet.
Public propertyDefaultColumnWidth Gets or sets default column width.
Public propertyHeadersFooters Gets or sets headers/footers for the sheet.
Public propertyName Gets or sets worksheet name.
Public propertyPictures Gets ExcelPictureCollection containing images.
Public propertyPrintOptions Contains print related options.
Public propertyProtected Gets or sets the worksheet protection flag.
Public propertyRows Gets collection of all rows in the worksheet.
Public propertyViewOptions Contains view related options.
Public propertyVisibility Gets or sets the worksheet visible property.
Top
Methods
 NameDescription
Public methodCalculateMaxUsedColumns Finds the number of columns used.
Public methodDelete Deletes this worksheet from the workbook.
Public methodEqualsDetermines whether the specified object is equal to the current object.
(Inherited from Object)
Public methodGetHashCodeServes as the default hash function.
(Inherited from Object)
Public methodGetTypeGets the Type of the current instance.
(Inherited from Object)
Public methodGetUsedCellRange Calculates cell range that is used in the worksheet.
Public methodInsertCopy Inserts a copy of an existing worksheet before the current worksheet.
Public methodInsertEmpty Inserts an empty worksheet before the current worksheet.
Public methodToStringReturns a string that represents the current object.
(Inherited from Object)
Top
Remarks

A specific cell (ExcelCell) can be accessed either trough ExcelRow.Cells, ExcelColumn.Cells or ExcelWorksheet.Cells property. Anyway, you can access the cell by the index or by the cell name (for example, "A1").

See Also