Worksheet Properties (Microsoft.Office.Tools.Excel)

Switch on low bandwidth view

Collapse All

This page is specific to

Microsoft Visual Studio 2005/.NET Framework 2.0

Other versions are also available for the following:

Excel Object Model Reference (Visual Studio Tools for Office)

Worksheet Properties

Public Properties

(see also Protected Properties )

	Name	Description
	_CodeName
	_DisplayRightToLeft
	Application	This property gets a Microsoft.Office.Interop.Excel.Application that represents the Microsoft Office Excel application.
	AutoFilter	Gets a Microsoft.Office.Interop.Excel.AutoFilter if filtering is on. Gets a null reference (Nothing in Visual Basic) if filtering is off.
	AutoFilterMode	Gets or sets a value that indicates whether the AutoFilter drop-down arrows are currently displayed on the sheet.
	BindingContext	(Inherited from BindableComponent.)
	Cells	Gets a Range object that represents all the cells on the worksheet (not just the cells that are currently in use).
	CircularReference	Gets a Range object that represents the range containing the first circular reference on the sheet, or gets a null reference (Nothing in Visual Basic) if there is no circular reference on the sheet.
	CodeName
	Columns	Gets a Range object that represents all the columns on the worksheet.
	Comments	Gets a Microsoft.Office.Interop.Excel.Comments collection that represents all the comments for the worksheet.
	ConsolidationFunction	Gets the function code used for the current consolidation.
	ConsolidationOptions	Gets a three-element Array of consolidation options.
	ConsolidationSources	Gets an Array of strings that name the source sheets and ranges for the worksheet's current consolidation.
	Container	(Inherited from Component.)
	Controls	Gets the collection of controls contained within the worksheet.
	Creator	Gets a value that indicates the application in which the worksheet was created.
	CustomProperties	Gets a Microsoft.Office.Interop.Excel.CustomProperties object representing the identifier information associated with a worksheet.
	DataBindings	(Inherited from BindableComponent.)
	DisplayAutomaticPageBreaks
	DisplayPageBreaks	Gets or sets a value that indicates whether page breaks (both automatic and manual) on the worksheet are displayed.
	DisplayRightToLeft	Gets or sets a value that indicates whether the worksheet is displayed from right to left instead of from left to right.
	EnableAutoFilter	Gets or sets a value that indicates whether AutoFilter arrows are enabled when user-interface-only protection is turned on.
	EnableCalculation	Gets or set a value that indicates whether Microsoft Office Excel automatically recalculates the worksheet when necessary.
	EnableOutlining	Gets or sets a value that indicates whether outlining symbols are enabled when user-interface-only protection is turned on.
	EnablePivotTable	Gets or sets a value that indicates whether PivotTable controls and actions are enabled when user-interface-only protection is turned on.
	EnableSelection	Gets or sets a value indicating which cells can be selected on the sheet.
	FilterMode	Gets a value that indicates whether the worksheet is in filter mode.
	HPageBreaks	Gets an Microsoft.Office.Interop.Excel.HPageBreaks collection that represents the horizontal page breaks on the sheet.
	Hyperlinks	Gets a Microsoft.Office.Interop.Excel.Hyperlinks collection that represents the hyperlinks for the range or worksheet.
	Index	Gets the index number of the worksheet within the collection of worksheets.
	InnerObject	Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the underlying native object for the Worksheet.
	ListObjects	Gets a collection of Microsoft.Office.Interop.Excel.ListObject objects in the worksheet.
	MailEnvelope	Gets an e-mail header for the worksheet.
	Name	Gets or sets the name of the worksheet.
	Names	Gets a Microsoft.Office.Interop.Excel.Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix).
	Next	Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the next sheet.
	OnCalculate
	OnData
	OnDoubleClick
	OnEntry
	OnSheetActivate
	OnSheetDeactivate
	Outline	Gets an Microsoft.Office.Interop.Excel.Outline that represents the outline for the worksheet.
	PageSetup	Gets a Microsoft.Office.Interop.Excel.PageSetup that contains all the page setup settings for the worksheet.
	Parent	Gets the parent object for the worksheet.
	Previous	Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the previous sheet.
	ProtectContents	Gets a value that indicates whether the contents of the worksheet (the individual cells) are protected.
	ProtectDrawingObjects	Gets a value that indicates whether shapes are protected.
	Protection	Gets a Microsoft.Office.Interop.Excel.Protection object that represents the protection options of the worksheet.
	ProtectionMode	Gets a value that indicates whether user interface-only protection is turned on.
	ProtectScenarios	Gets a value that indicates whether worksheet scenarios are protected.
	QueryTables	Gets the Microsoft.Office.Interop.Excel.QueryTables collection that represents all the query tables on the worksheet.
	Range	Gets a Microsoft.Office.Interop.Excel.Range object that represents a cell or a range of cells.
	Rows	Gets a Range object that represents all the rows on the worksheet.
	Scripts	Gets the Microsoft.Office.Core.Scripts collection, which contains Script objects representing blocks of script or code in the worksheet when it is saved as a Web page.
	ScrollArea	Gets or sets the range where scrolling is allowed, as an A1-style range reference.
	Shapes	Gets a Microsoft.Office.Interop.Excel.Shapes object that represents all the shapes on the worksheet.
	Site	(Inherited from Component.)
	SmartTags	Gets a Microsoft.Office.Interop.Excel.SmartTags object representing the collection of smart tags for the worksheet.
	StandardHeight	Gets the standard (default) height of all the rows in the worksheet, in points.
	StandardWidth	Gets or sets the standard (default) width of all the columns in the worksheet.
	Tab	Gets a Microsoft.Office.Interop.Excel.Tab for the worksheet.
	Tag	Gets or sets the object that contains data about the worksheet.
	TransitionExpEval	Gets or sets a value that indicates whether Microsoft Office Excel uses Lotus 1-2-3 expression evaluation rules for the worksheet.
	TransitionFormEntry	Gets or sets a value that indicates whether Microsoft Office Excel uses Lotus 1-2-3 formula entry rules for the worksheet.
	Type	Gets the worksheet type.
	UsedRange	Gets a Microsoft.Office.Interop.Excel.Range object that represents the used range on the worksheet.
	Visible	Gets or sets a Microsoft.Office.Interop.Excel.XlSheetVisibility value that determines whether the object is visible.
	VPageBreaks	Gets a Microsoft.Office.Interop.Excel.VPageBreaks collection that represents the vertical page breaks on the sheet.

Top

Protected Properties

	Name	Description
	CanRaiseEvents	(Inherited from Component.)
	ContainerComponent	(Inherited from BindableComponent.)
	DesignMode	(Inherited from Component.)
	Events	(Inherited from Component.)

Top

Reference

Worksheet Class
Microsoft.Office.Tools.Excel Namespace

Concepts

Host Items and Host Controls Overview