Message-ID: <1848170537.10223.1711718130420.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10222_1274264003.1711718130420" ------=_Part_10222_1274264003.1711718130420 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Worksheet.ViewState

Worksheet.ViewState

Description

=20

Sets or returns the worksheet's viewing mode.

=20
C#
=20
 public SheetViewState ViewState{ get; set; }
=20
=20
vb.net
=20
Public Property ViewState() As SheetViewState
=20
=20

Examples

=20
C#
=20
//--- Get ViewState
Worksheet.SheetViewState state =3D ws.ViewState;

//--- Set ViewState
ws.ViewState =3D Worksheet.SheetViewState.PageBreak;
=20
=20
vb.net
=20
'--- Get ViewState
Dim state As Worksheet.SheetViewState =3D ws.ViewState

'--- Set ViewState
ws.ViewState =3D Worksheet.SheetViewState.PageBreak
=20
=20

Exceptions

=20
ArgumentException
Att= empting to set=20 ViewState to=20 PageLayout in an Excel 2003 or earlier workbook will throw an= =20 ArgumentException.=20

Remarks

=20

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

=20

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

=20

Setting this property to null will set the mode to No= rmal.

------=_Part_10222_1274264003.1711718130420--