Page History

...

Excerpt
Sets or returns the worksheet's viewing mode, which may be either normal or page break mode.

Signature

	C#
	C#

 public SheetViewState ViewState{ get; set; }

...

Example

Code Block

	csharp
	csharp
title	C#


          //--- Get ViewState
          Worksheet.SheetViewState state = ws.ViewState;

          //--- Set ViewState
          ws.ViewState = Worksheet.SheetViewState.PageBreak;

Code Block

	vb.net
	vb.net
title	vb.net


          '--- Get ViewState
          Dim state As Worksheet.SheetViewState = ws.ViewState

          '--- Set ViewState
          ws.ViewState = Worksheet.SheetViewState.PageBreak

Exceptions

Exception

	ArgumentException
	ArgumentException

Attempting to set ViewState to PageLayout in an Excel 2003 or earlier workbook will throw an ArgumentException.

Remarks

The viewing mode may be any of the values defined by SheetViewState. By default, worksheets are in Normal mode.

Note that only Excel 2007 or later workbooks support PageLayout mode.

Setting this property to null will set the mode to Normal.

Space Shortcuts

Page tree

Versions Compared

Old Version 1

New Version 2

Key