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