ブックの参照

PythonからExcel

The easiest way to connect to a book is offered by xw.Book: it looks for the book in all app instances and returns an error, should the same book be open in multiple instances. To connect to a book in the active app instance, use xw.books and to refer to a specific app, use:

>>> app = xw.App()  # or something like xw.apps[10559] for existing apps, get the available PIDs via xw.apps.keys()
>>> app.books['Book1']

Note that you usually should use App as a context manager as this will make sure that the Excel instance is closed and cleaned up again properly:

with xw.App() as app:
    book = app.books['Book1']

	xw.Book	xw.books
新規ブック	xw.Book()	xw.books.add()
保存されていないブック	xw.Book('Book1')	xw.books['Book1']
（完全な）名前でブックを指定	xw.Book(r'C:/path/to/file.xlsx')	xw.books.open(r'C:/path/to/file.xlsx')

注釈

When specifying file paths on Windows, you should either use raw strings by putting an r in front of the string or use double back-slashes like so: C:\\path\\to\\file.xlsx.

ExcelからPython (RunPython)

To reference the calling book when using RunPython in VBA, use xw.Book.caller(), see Call Python with "RunPython". Check out the section about Debugging to see how you can call a script from both sides, Python and Excel, without the need to constantly change between xw.Book.caller() and one of the methods explained above.

ユーザー定義関数（User Defined Functions, UDFs）

Unlike RunPython, UDFs don't need a call to xw.Book.caller(), see User Defined Functions (UDFs). You'll usually use the caller argument which returns the xlwings range object from where you call the function.