Export (0) Print
Expand All

Sheets Interface 

A collection of all the sheets in the specified or active workbook.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
Public Class heetsImplementation
	Implements Sheets
End Class
Dim heetsImplementation1 As New heetsImplementation()

public interface Sheets : IEnumerable
public interface Sheets implements IEnumerable
public interface Sheets implements IEnumerable

The Sheets collection can contain Chart or Worksheet objects. The Sheets collection is useful when you want to return sheets of any type. If you need to work with sheets of only one type, see the object topic for that sheet type.

Use the Sheets property to return the Sheets collection.

Use the Add method to create a new sheet and add it to the collection.

Use Sheets(index), where index is the sheet name or index number, to return a single Chart or Worksheet object.

Use Sheets(array) to specify more than one sheet.


Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft