Worksheet Properties

The Worksheet type exposes the following members.

Properties

	Name	Description
	ActiveCell	Gets or sets the active cell in the worksheet.
	AllowEditRanges	Gets the allow edit range collection in the worksheet.
	AutoFilter	Represents auto filter for the specified worksheet.
	BackgroundImage	Gets and sets worksheet background image.
	Cells	Gets the Cells collection.
	CellWatches	Gets collection of cells on this worksheet being watched in the 'watch window'.
	Charts	Gets a Chart collection
	CheckBoxes	Gets a CheckBox collection.
	CodeName	Gets worksheet code name.
	Comments	Gets the Comment collection.
	ConditionalFormattings	Gets the ConditionalFormattings in the worksheet.
	CustomProperties	Gets an object representing the identifier information associated with a worksheet.
	DisplayRightToLeft	Indicates if the specified worksheet is displayed from right to left instead of from left to right. Default is false.
	DisplayZeros	True if zero values are displayed.
	ErrorCheckOptions	Gets error check setting applied on certain ranges.
	FirstVisibleColumn	Represents first visible column index.
	FirstVisibleRow	Represents first visible row index.
	HasAutofilter	Indicates whether this worksheet has auto filter.
	HorizontalPageBreaks	Gets the HorizontalPageBreakCollection collection.
	Hyperlinks	Gets the HyperlinkCollection collection.
	Index	Gets the index of sheet in the worksheet collection.
	IsGridlinesVisible	Gets or sets a value indicating whether the gridelines are visible.Default is true.
	IsOutlineShown	Indicates whether to show outline.
	IsPageBreakPreview	Indicates whether the specified worksheet is shown in normal view or page break preview.
	IsProtected	Indicates if the worksheet is protected.
	IsRowColumnHeadersVisible	Gets or sets a value indicating whether the worksheet will display row and column headers. Default is true.
	IsRulerVisible	Indicates whether the ruler is visible. This property is only applied for page break preview.
	IsSelected	Indicates whether this worksheet is selected when the workbook is opened.
	IsVisible	Represents if the worksheet is visible.
	ListObjects	Gets all ListObjects in this worksheet.
	Name	Gets or sets the name of the worksheet.
	OleObjects	Represents a collection of OleObject in a worksheet.
	Outline	Gets the outline on this worksheet.
	PageSetup	Represents the page setup description in this sheet.
	Pictures	Gets a Picture collection.
	PivotTables	Gets all pivot tables in this worksheet.
	Protection	Represents the various types of protection options available for a worksheet. Supports advanced protection options in ExcelXP and above version.
	QueryTables	Gets the queryTables in the worksheet.
	Scenarios	Gets the collection of Scenario.
	Shapes	Returns all drawing shapes in this worksheet.
	ShowFormulas	Indicates whether to show formulas or their results.
	Slicers	Get the Slicer collection in the worksheet
	SmartTagSetting	Gets all SmartTagCollection objects of the worksheet.
	SparklineGroupCollection	Gets the sparkline group collection in the worksheet.
	TabColor	Represents worksheet tab color.
	TabId	Specifies the internal identifier for the sheet.
	TextBoxes	Gets a TextBox collection.
	TransitionEntry	Indicates whether the Transition Formula Entry (Lotus compatibility) option is enabled.
	TransitionEvaluation	Indicates whether the Transition Formula Evaluation (Lotus compatibility) option is enabled.
	Type	Represents worksheet type.
	UniqueId	Gets and sets the unique id, it is same as {15DB5C3C-A5A1-48AF-8F25-3D86AC232D4F}.
	Validations	Gets the data validation setting collection in the worksheet.
	VerticalPageBreaks	Gets the VerticalPageBreakCollection collection.
	ViewType	Gets and sets the view type.
	VisibilityType	Indicates the visible state for this sheet.
	Workbook	Gets the workbook object which contains this sheet.
	Zoom	Represents the scaling factor in percentage. It should be between 10 and 400.

Reference

Worksheet Class

Aspose.Cells Namespace