WorksheetView Interface

Definition

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

public interface class WorksheetView
[System.Runtime.InteropServices.Guid("00024487-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface WorksheetView
Public Interface WorksheetView
Attributes

Remarks

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

Properties

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

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

DisplayFormulas

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

DisplayGridlines

True if gridlines are displayed. Read/write.

DisplayHeadings

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

DisplayOutline

True if outline symbols are displayed.

DisplayZeros

True if zero values are displayed. Read/write .

Parent

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

Sheet

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

Applies to