Message-ID: <2053103873.8659.1711654113342.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8658_1212689529.1711654113342" ------=_Part_8658_1212689529.1711654113342 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Worksheets.Select(Object())

Worksheets.Select(Object())

Description

= =20

Set the sheets that will be selected when the workbook is opened in Exce= l.

=20
C#
=20
 public void Select(System.Object[] sheets)
=20
=20
vb.net
=20
Public Sub [Select](ByVal sheets As Object())
=20
=20

Parameters

=20
sheets
Array of sheet in= dexes or sheet names.=20

Exceptions

=20
ArgumentException<= /h6> If an item in the array is not of type int or string; or if it does no= t correspond to a worksheet (i.e. specifies a name for a worksheet that doe= s not exist, or an index that does not correspond to an existing worksheet = position)=20

Remarks

=20

Each object in the array should be an int or a string. If it is an int, = the worksheet at the specified position will be selected. If it is a string= , the worksheet with the specified name will be selected.

=20

If the array is empty, there will be no effect. The worksheets that were= previously selected will still be selected.

=20

The last object in the array specifies the worksheet that will be visibl= e when first opened in Excel. The other parameters specify the worksheets t= hat will be selected, but will not be displayed in the main Excel window wh= en you first open the file.

=20

Examples

=20
C#
=20
sheets.Select(arrSheets);
=20
=20
vb.net
=20
sheets.Select(arrSheets)
=20
------=_Part_8658_1212689529.1711654113342--