GemBox.Spreadsheet

ExcelWorksheet Properties

The properties of the ExcelWorksheet class are listed below. For a complete list of ExcelWorksheet class members, see the ExcelWorksheet Members topic.

Public Instance Properties

Cells Gets CellRange with all the cells (ExcelCell) in the worksheet.
Columns Gets collection of all columns (ExcelColumn) in the worksheet.
DefaultColumnWidth Gets or sets default column width.
HasHeadersFooters Returns true if worksheet has headers/footers.
HasSplitOrFreezePanes Returns true if worksheet has split or freeze panes.
HeadersFooters Gets or sets headers/footers for the sheet.
HorizontalPageBreaks Gets collection of all horizontal page breaks (HorizontalPageBreak) in the worksheet.
Hyperlinks Gets hyperlinks in this sheet.
Name Gets or sets worksheet name.
NamedRanges Gets NamedRangeCollection containing descriptive names which are used to represent cells, ranges of cells, formulas, or constant values.
Panes Gets or sets the panes in the worksheet.
Pictures Gets ExcelPictureCollection containing images.
PrintOptions Contains MS Excel print and print related options.
Protected Gets or sets the worksheet protection flag.
Rows Gets collection of all rows (ExcelRow) in the worksheet.
VerticalPageBreaks Gets collection of all vertical page breaks (VerticalPageBreak) in the worksheet.
ViewOptions Contains MS Excel display and view related options.
Visibility Gets or sets the worksheet visible property.

See Also

ExcelWorksheet Class | GemBox.Spreadsheet Namespace | ExcelRow | ExcelColumn | ExcelCell