General Process of Using xlwings

Method

Import xlwings package

import xlwings as xw    

Create or get main objects

app=xw.App()

bk=app.books.active    #Get the active workbook

sht=bk.sheets.active    #Get the active sheet

Data processing

sht.range(‘A1’).value=10

Save the workbook, close it and exit

bk.close()

app.kill()

Sample Code

#General Process of Using the xlwings Package  

import xlwings as xw    #Import the xlwings package 

app=xw.App()    #Create an Excel application  
bk=app.books.active    #Get the active workbook 
sht=bk.sheets.active    #Get the active worksheet  

#Process data 
sht.range("A1").value=10

#Close the workbook
bk.close()
#Exit the application
app.kill()