Gets or sets the value which indicates whether to display row and column headers. Syntax Property Value The value which indicates whether to display row and column headers. Remarks The row and column headers show the identifier of the row or column. They also allow the user to easily select all cells in a row or c...
Gets or sets the value which indicates whether to show rulers in the page layout view. Syntax Property Value The value which indicates whether to show rulers in the page layout view. Remarks When this value is True, one ruler will display above the column headers of the active page in page layout view. Another rul...
Gets or sets the value which indicates whether zero values are shown in cells. Syntax Property Value The value which indicates whether zero values are shown in cells. Remarks If this value is True, cells with a value of zero will display their values; otherwise, those cells will display as blanks.
Gets the settings which control the unfrozen panes in the worksheet. Syntax Property Value The settings which control the unfrozen panes in the worksheet. Remarks For these settings to be saved in the workbook file, PanesAreFrozen must be False. Note: Frozen and unfrozen panes cannot be used simultaneously, so dep...
Gets or sets the current view of the worksheet. Syntax Property Value The current view of the worksheet. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The value assigned is not defined in the WorksheetView enumeration. Remarks The view determines the overall display of the wor...
Gets or sets the visibility of the worksheet. Syntax Property Value The visibility of the worksheet. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The value assigned is not defined in the WorksheetVisibility enumeration. Remarks The visibility determines whether the worksheets...
A collection of display text values. Syntax
Public Properties Public Methods
Public Methods
Public Properties