How To Reference, Activate, Save, and Close Workbooks Using xlwings?

Method

Reference a workbook

#xlwings

bk=xw.books[0]

#bk2=xw.books(2)

#pid=xw.apps.keys()

#app2=xw.apps[pid[0]]

Activate a workbook

#xlwings

#xw.books(1).activate()

#xw.books.active.name

#xlwings API

#app.api.Workbooks(1).Activate()

#app.api.ActiveWorkbook.Name

Save the workbook

#xlwings

bk.save()

#xlwings API

#bk=app.api.Workbooks(1)

#bk=app.api.Workbooks(“Workbook1”)

#bk.SaveAs(r”D:\test.xlsx”)

#bk.SaveCopyAs(r”D:\test.xlsx”)

Close the workbook

#xlwings

bk.close()

#xlwings API

app.api.Workbooks(1).Close()

Sample Code

#Reference, activate, save, and close a workbook

import xlwings as xw    #Import the xlwings package

app=xw.App()
app.books.add()

#xlwings
bk=xw.books[0]
#bk2=xw.books(2)

#pid=xw.apps.keys()
#app2=xw.apps[pid[0]]

#Activate a workbook
#xlwings
#xw.books(1).activate()
#xw.books.active.name

#xlwings API
#app.api.Workbooks(1).Activate()
#app.api.ActiveWorkbook.Name

#Save the workbook
#xlwings
#bk.save()

#xlwings API
#bk=app.api.Workbooks(1)
#bk=app.api.Workbooks("Workbook1")
#bk.SaveAs(r"D:\test.xlsx")
#bk.SaveCopyAs(r"D:\test.xlsx")

#Close the workbook
#xlwings
bk.close()

#xlwings API
#app.api.Workbooks(1).Close()

app.kill()