Expand Minimize

WorksheetBase Properties

The WorksheetBase type exposes the following members.

  Name Description
Public property _CodeName Infrastructure.
Public property _DisplayRightToLeft Infrastructure.
Public property Application Gets a Microsoft.Office.Interop.Excel.Application object that represents the Microsoft Office Excel application.
Public property AutoFilter Gets a Microsoft.Office.Interop.Excel.AutoFilter that provides information about filtered lists on the worksheet if filtering is enabled. Gets null if filtering is off.
Public property AutoFilterMode Gets or sets a value that indicates whether filtering is currently enabled on the worksheet (that is, whether the filter drop-down arrows are currently displayed).
Public property Base Gets the Worksheet object that this WorksheetBase object extends.
Public property BindingContext Infrastructure.
Public property Cells Gets a Range object that represents all the cells on the worksheet (not just the cells that are currently in use).
Public property CircularReference Gets a Range object that represents the range containing the first circular reference on the sheet, or gets null if there is no circular reference on the sheet.
Public property CodeName Infrastructure.
Public property Columns Gets a Range object that represents one or more columns on the worksheet.
Public property Comments Gets a Microsoft.Office.Interop.Excel.Comments collection that represents all the comments for the worksheet.
Public property ConsolidationFunction Gets the function code used for the current consolidation.
Public property ConsolidationOptions Gets a three-element Array of consolidation options.
Public property ConsolidationSources Gets an Array of strings that name the source sheets and ranges for the worksheet's current consolidation.
Public property Controls Gets the collection of managed controls that are contained on the worksheet.
Public property Creator Gets a value that indicates the application in which the worksheet was created.
Public property CustomProperties Gets a Microsoft.Office.Interop.Excel.CustomProperties object representing the identifier information associated with a worksheet.
Public property DataBindings Infrastructure.
Public property DataHost Infrastructure.
Public property DisplayAutomaticPageBreaks Infrastructure.
Public property DisplayPageBreaks Gets or sets a value that indicates whether page breaks (both automatic and manual) on the worksheet are displayed.
Public property DisplayRightToLeft Gets or sets a value that indicates whether the worksheet is displayed from right to left instead of from left to right.
Public property EnableAutoFilter Gets or sets a value that indicates whether AutoFilter arrows are enabled when user-interface-only protection is turned on.
Public property EnableCalculation Gets or set a value that indicates whether Microsoft Office Excel automatically recalculates the worksheet when necessary.
Public property EnableFormatConditionsCalculation Gets or sets a value that determines whether conditional formats will occur automatically.
Public property EnableOutlining Gets or sets a value that indicates whether outlining symbols are enabled when user-interface-only protection is turned on. This type or member is intended to be used only in projects for the 2007 Microsoft Office system. Smart tags are deprecated in Office 2010.
. This type or member is intended to be used only in projects for the 2007 Microsoft Office system. Smart tags are deprecated in Office 2010.
.
Public property EnablePivotTable Gets or sets a value that indicates whether PivotTable controls and actions are enabled when user-interface-only protection is turned on.
Public property EnableSelection Gets or sets a value indicating which cells can be selected on the sheet.
Public property FilterMode Gets a value that indicates whether the worksheet is actively filtering data.
Public property HostContext Infrastructure.
Public property HPageBreaks Gets an Microsoft.Office.Interop.Excel.HPageBreaks collection that represents the horizontal page breaks on the sheet.
Public property Hyperlinks Gets a Microsoft.Office.Interop.Excel.Hyperlinks collection that represents the hyperlinks for the range or worksheet.
Public property Index Gets the index number of the worksheet within the collection of worksheets.
Public property InnerObject Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the underlying native object for the WorksheetBase.
Public property ItemProvider Infrastructure.
Public property ListObjects Gets a collection of Microsoft.Office.Interop.Excel.ListObject objects in the worksheet.
Public property MailEnvelope Gets an e-mail header for the worksheet.
Public property Name Gets or sets the name of the worksheet.
Public property Names Gets a Microsoft.Office.Interop.Excel.Names collection that represents all the worksheet-specific names (names defined with the "WorksheetName!" prefix).
Public property Next Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the next sheet.
Public property OnCalculate Infrastructure.
Public property OnData Infrastructure.
Public property OnDoubleClick Infrastructure.
Public property OnEntry Infrastructure.
Public property OnSheetActivate Infrastructure.
Public property OnSheetDeactivate Infrastructure.
Public property Outline Gets an Microsoft.Office.Interop.Excel.Outline that represents the outline for the worksheet.
Public property PageSetup Gets a Microsoft.Office.Interop.Excel.PageSetup that contains all the page setup settings for the worksheet.
Public property Parent Gets the parent object for the worksheet.
Public property Previous Gets a Microsoft.Office.Interop.Excel.Worksheet that represents the previous sheet.
Public property PrintedCommentPages Gets the number of comment pages that will be printed for the current worksheet. This property can be used only in Excel 2010 projects.
Public property ProtectContents Gets a value that indicates whether the contents of the worksheet (the individual cells) are protected.
Public property ProtectDrawingObjects Gets a value that indicates whether shapes are protected.
Public property Protection Gets a Microsoft.Office.Interop.Excel.Protection object that represents the protection options of the worksheet.
Public property ProtectionMode Gets a value that indicates whether user interface-only protection is turned on.
Public property ProtectScenarios Gets a value that indicates whether worksheet scenarios are protected.
Public property QueryTables Gets the Microsoft.Office.Interop.Excel.QueryTables collection that represents all the query tables on the worksheet.
Public property Range Gets a Microsoft.Office.Interop.Excel.Range object that represents a cell or a range of cells.
Public property Rows Gets a Range object that represents one or more rows on the worksheet.
Public property 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.
Public property ScrollArea Gets or sets the range where scrolling is allowed, as an A1-style range reference.
Public property Shapes Gets a Microsoft.Office.Interop.Excel.Shapes object that represents all the shapes on the worksheet.
Public property Site Infrastructure.
Public property SmartTags Gets a Microsoft.Office.Interop.Excel.SmartTags object representing the collection of smart tags for the worksheet.
Public property Sort Gets the sorted values in the current worksheet.
Public property StandardHeight Gets the standard (default) height of all the rows in the worksheet, in points.
Public property StandardWidth Gets or sets the standard (default) width of all the columns in the worksheet.
Public property Tab Gets a Microsoft.Office.Interop.Excel.Tab for the worksheet.
Public property Tag Gets or sets the object that contains data about the worksheet.
Public property TransitionExpEval Gets or sets a value that indicates whether Microsoft Office Excel uses Lotus 1-2-3 expression evaluation rules for the worksheet.
Public property TransitionFormEntry Gets or sets a value that indicates whether Microsoft Office Excel uses Lotus 1-2-3 formula entry rules for the worksheet.
Public property Type Gets the worksheet type.
Public property UsedRange Gets a Microsoft.Office.Interop.Excel.Range object that represents all the cells that have contained a value at any time.
Public property Visible Gets or sets a Microsoft.Office.Interop.Excel.XlSheetVisibility value that determines whether the object is visible.
Public property VPageBreaks Gets a Microsoft.Office.Interop.Excel.VPageBreaks collection that represents the vertical page breaks on the sheet.
Top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft