WorksheetView WorksheetView WorksheetView Interface


A collection of all the WorksheetView objects in the specified or active workbook.

public interface class WorksheetView
public interface WorksheetView
Public Interface WorksheetView


Controls the look and feel of the application or workbook level view by working with properties such as DisplayFormulas, DisplayGridlines, and DisplayHeadings.


Application Application Application

When used without an object qualifier, this property returns an _Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an _Application object that represents the creator of the specified object. Read-only.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only.

DisplayFormulas DisplayFormulas DisplayFormulas

Returns or sets if formulas should be displayed or hidden in the current worksheet view. Read/write.

DisplayGridlines DisplayGridlines DisplayGridlines

True if gridlines are displayed. Read/write.

DisplayHeadings DisplayHeadings DisplayHeadings

True if both row and column headings are displayed; False if no headings are displayed. Read/write.

DisplayOutline DisplayOutline DisplayOutline

True if outline symbols are displayed.

DisplayZeros DisplayZeros DisplayZeros

True if zero values are displayed. Read/write .

Parent Parent Parent

Returns the parent object for the specified object. Read-only.

Sheet Sheet Sheet

Returns the sheet name for the specified WorksheetView object. Read-only.

Applies to