Archive

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()

How To Create and Open Workbooks Using xlwings?

Method

• Creating a Workbook:

        bk=app.Workbooks.Add()

        bk=app.Workbooks.Add(constants.xlWBATChart)

        bk=app.Workbooks.Add(r’C:\1.xlsx’)

• Opening a Workbook:

        bk=app.Workbooks.Open(r’D:\test.xlsx’)

        bk=app.Workbooks.Open(root+r’/test.xlsx’)

 

#Create a workbook

#xlwings

bk=xw.books.add()

#Or

#bk=xw.Book()

#Or

#app=xw.App()

#bk=xw.books.active

 

#xlwings API

#app=xw.App()

#bk=app.api.Workbooks.Add()

 

#Open a workbook

#xlwings

#bk=xw.books.open(r’D:\1.xlsx’)   ”d:/1.xlsx’

 

#xlwings API

#bk=app.api.Workbooks.Open(r’D:\1.xlsx’)

 

Sample Code

#Creating and Opening Workbooks

import xlwings as xw    #Import the xlwings package

#Create a workbook
#xlwings
#app=xw.App()
#bk=xw.books.add()
#Or
#bk=xw.Book()
#Or
#app=xw.App()
#bk=xw.books.active

#xlwings API
#app=xw.App()
#bk=app.api.Workbooks.Add()

#Open a workbook
#xlwings
app=xw.App()
bk=app.books.open(r'data.xlsx')

#xlwings API
#bk=app.api.Workbooks.Open(r'data.xlsx')

bk.close()
app.kill()