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

Worksheets

Description

=20

The Worksheets class represents= the set of worksheets in an Excel workbook. This object is used to manage = (add, copy, remove, etc.) the worksheets in the workbook To return a = Worksheets object, use Workbook.Worksheets.

=20
C#
=20
[DefaultMember("Item")]
 public sealed class Worksheets : System.Collections.Generic.IEnumerable<=
;Worksheet>
=20
=20
vb.net
=20
<DefaultMember("Item")> _
=09Public NotInheritable Class Worksheets
=09=09Implements System.Collections.Generic.IEnumerable(Of Worksheet)
=20
=20

Properties

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

Co= unt

Returns the number of worksheets in the workbook= .
=20

Indexers

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

Item(Int32)

Returns the worksheet at the specified position.= This property is an indexer for the W= orksheets class.

Item(String)

Returns the worksheet with the specified name. T= his property is an indexer for the Wor= ksheets class.
=20

Methods

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

CopySheet(Worksheet, Int32, String)

Copies a worksheet in the workbook to another po= sition in the same workbook.

CreateChartsheet(ChartType, String)

Creates a new chartsheet after the last existing= worksheet in this workbook.

CreateChartsheet(ChartType, String, Int32)

Creates a new Chartsheet at a specified position= in the workbook.

CreateWorksheet(String)

Creates a new worksheet after the last existing = worksheet in this workbook.

CreateWorksheet(String, Int32)

Creates a new worksheet at a specified position = in the workbook.

Delete(Int32)

Deletes a worksheet from the workbook.

Delete(String)

Deletes a worksheet from the workbook.

GetEnumerator()

Returns an IEnumerator for the individual Wo= rksheets in a Worksheets object

InsertSheet(String, Int32)

Inserts a new worksheet into the workbook at a s= pecified position.

MoveSheet(Worksheet, Int32)

Moves a worksheet to a different position in the= workbook.

Select(Object())

Set the sheets that will be selected when the wo= rkbook is opened in Excel.
------=_Part_9138_1240548988.1711677511997--