How To Select and Clear Cells (Ranges) Using xlwings?

Method

Select

#xlwings

sht.range(‘A1:B10’).select()

 

#xlwings API

#sht.api.Range(‘A1:B10’).Select()

#sht.api.Range(‘A1:B10’).Activate()

 

Select non-contiguous cell ranges

#xlwings

#sht.range(‘A1:A5,C3,E1:E5’).select()

 

#xlwings API

#sht.api.Range(‘A1:A5,C3,E1:E5’).Activate()

#sht.api.Range(‘A1:A5,C3,E1:E5’).Select()

 

Clear all content from a cell range

#xlwings

#sht.range(‘B2:D5′).clear()

 

#xlwings API

#sht.api.Range(‘B2:D5′).Clear()

 

Clear text content of a cell

#xlwings

#sht.range(‘B2:D5′).clear_contents()

 

#xlwings API

#sht.api.Range(‘B2:D5′).ClearContents()

 

Clear cell comments

#xlwings API

#sht.api.Range(‘B2:D5′).ClearComments()

 

Clear cell formatting

#xlwings API

#sht.api.Range(‘B2:D5′).ClearFormats()

Sample Code

#Select and clear cells 

import xlwings as xw  #Import the xlwings package

app=xw.App()
bk=app.books.open('special.xlsx')
sht=bk.sheets.active  #Get the active worksheet

#Select
#xlwings
#sht.range('A1:B10').select()

#xlwings API
#sht.api.Range('A1:B10').Select()
#sht.api.Range('A1:B10').Activate()

#Select non-contiguous cell ranges
#xlwings
#sht.range('A1:A5,C3,E1:E5').select()

#xlwings API
#sht.api.Range('A1:A5,C3,E1:E5').Activate()
#sht.api.Range('A1:A5,C3,E1:E5').Select()

#Clear all content from a cell range
#xlwings
#sht.range('B2:D5').clear()

#xlwings API
sht.api.Range('B2:D5').Clear()

#Clear text content of a cell
#xlwings
#sht.range('B2:D5').clear_contents()

#xlwings API
#sht.api.Range('B2:D5').ClearContents()

#Clear cell comments
#xlwings API
#sht.api.Range('B2:D5').ClearComments()

#Clear cell formatting
#xlwings API
#sht.api.Range('B2:D5').ClearFormats()

#bk.close()
#app.kill()