Workbooks Workbooks Workbooks Interface

Definition

Eine Auflistung aller der Workbook -Objekte, die derzeit in der Microsoft Excel-Anwendung zu öffnen. A collection of all the Workbook objects that are currently open in the Microsoft Excel application.

public interface class Workbooks : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("000208DB-0000-0000-C000-000000000046")]
public interface Workbooks : System.Collections.IEnumerable
Public Interface Workbooks
Implements IEnumerable
Attribute
Implementiert

Hinweise

Verwendung der Workbooks Eigenschaft, um die Workbooks -Auflistung zurückzugeben. Use the Workbooks property to return the Workbooks collection.

Verwendung der Add(Object) -Methode, um eine neue, leere Arbeitsmappe zu erstellen und der Auflistung hinzugefügt. Use the Add(Object) method to create a new, empty workbook and add it to the collection.

Verwendung der Open(String, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) -Methode, um eine Datei zu öffnen. Use the Open(String, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) method to open a file.

Weitere Informationen zur Verwendung einer einzelnen Workbook -Objekts finden Sie unter der Workbook Objekt. For more information about using a single Workbook object, see the Workbook object.

Eigenschaften

_Default[Object] _Default[Object] _Default[Object]

Für die interne Verwendung reserviert. Reserved for internal use.

Application Application Application

Gibt ein Application -Objekt, das die Anwendung Microsoft Excel darstellt. Returns an Application object that represents the Microsoft Excel application. Schreibgeschützt. Read-only.

Count Count Count

Gibt die Anzahl der Objekte in der Auflistung zurück. Returns the number of objects in the collection. Schreibgeschützter Integer-Wert. Read-only Integer.

Creator Creator Creator

Gibt eine 32-Bit-Ganzzahl, die die Anwendung angibt, in der das Objekt erstellt wurde. Returns a 32-bit integer that indicates the application in which this object was created. Wenn das Objekt in Microsoft Excel erstellt wurde, gibt diese Eigenschaft die Zeichenfolge XCEL zurück, dies entspricht die hexadezimale Zahl 5843454 c ist. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator. Read-only XlCreator.

Item[Object] Item[Object] Item[Object]

Gibt ein einzelnes Objekt aus einer Auflistung zurück. Returns a single object from a collection.

Parent Parent Parent

Gibt das übergeordnete Objekt für das angegebene Objekt zurück. Schreibgeschützt. Returns the parent object for the specified object. Read-only.

Methoden

__OpenText(String, Object, Object, Object, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object) __OpenText(String, Object, Object, Object, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object) __OpenText(String, Object, Object, Object, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Für die interne Verwendung reserviert. Reserved for internal use.

_Open(String, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) _Open(String, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) _Open(String, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Für die interne Verwendung reserviert. Reserved for internal use.

_OpenText(String, Object, Object, Object, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) _OpenText(String, Object, Object, Object, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) _OpenText(String, Object, Object, Object, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)
_OpenXML(String, Object) _OpenXML(String, Object) _OpenXML(String, Object)

Für die interne Verwendung reserviert. Reserved for internal use.

Add(Object) Add(Object) Add(Object)

Erstellt eine neue Arbeitsmappe. Creates a new workbook. Die neue Arbeitsmappe wird der aktiven Arbeitsmappe. The new workbook becomes the active workbook. Gibt eine Workbook Objekt. Returns a Workbook object.

CanCheckOut(String) CanCheckOut(String) CanCheckOut(String)

True falls von Microsoft Excel eine angegebene Arbeitsmappe von einem Server ausgecheckt werden kann. Boolean -Wert mit Lese-/Schreibzugriff. True if Microsoft Excel can check out a specified workbook from a server. Read/write Boolean.

CheckOut(String) CheckOut(String) CheckOut(String)

Kopiert die angegebene Arbeitsmappe von einem Server auf einen lokalen Computer zur Bearbeitung. Copies the specified workbook from a server to a local computer for editing.

Close() Close() Close()

Schließt das Objekt. Closes the object.

GetEnumerator() GetEnumerator() GetEnumerator()
Open(String, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Open(String, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) Open(String, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Öffnet eine Arbeitsmappe. Opens a workbook.

OpenDatabase(String, Object, Object, Object, Object) OpenDatabase(String, Object, Object, Object, Object) OpenDatabase(String, Object, Object, Object, Object)

Gibt ein Workbook -Objekt, das eine Datenbank darstellt. Returns a Workbook object representing a database.

OpenText(String, Object, Object, Object, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) OpenText(String, Object, Object, Object, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object) OpenText(String, Object, Object, Object, XlTextQualifier, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Lädt und analysiert eine Textdatei als eine neue Arbeitsmappe mit einem einzelnen Blatt, das die analysierten Textdateidaten enthält. Loads and parses a text file as a new workbook with a single sheet that contains the parsed text-file data.

OpenXML(String, Object, Object) OpenXML(String, Object, Object) OpenXML(String, Object, Object)

Öffnet eine XML-Datendatei an. Opens an XML data file. Gibt eine Workbook Objekt. Returns a Workbook object.

Gilt für: