英語で読む

次の方法で共有


Workbooks Members

[このトピックはプレリリース版のため将来変更される可能性があります。また、プレースホルダとしてブランクのトピックが含まれています。]

A collection of all the Workbook objects that are currently open in the Microsoft Excel application.

The following tables list the members exposed by the Workbooks type.

Public Properties

  Name Description
_Default  
Application Returns an Application object that represents the Microsoft Excel application. Read-only.
Count Returns the number of objects in the collection. Read-only Integer.
Creator Returns a 32-bit integer that indicates the application in which this object was created. 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.
Item Returns a single object from a collection.
Parent Returns the parent object for the specified object. Read-only.

Top

Public Methods

  Name Description
__OpenText  
_Open  
_OpenText  
_OpenXML  
Add Creates a new workbook. The new workbook becomes the active workbook. Returns a Workbook object.
CanCheckOut True if Microsoft Excel can check out a specified workbook from a server. Read/write Boolean.
CheckOut Copies the specified workbook from a server to a local computer for editing.
Close Closes the object.
GetEnumerator Returns an enumerator to support iterating through the collection.
Open Opens a workbook.
OpenDatabase Returns a Workbook object representing a database.
OpenText Loads and parses a text file as a new workbook with a single sheet that contains the parsed text-file data.
OpenXML Opens an XML data file. Returns a Workbook object.

Top

See Also

Reference

Workbooks Interface
Microsoft.Office.Interop.Excel Namespace