How To Reference Cells In a Cell Range Using xlwings?

Method

Coordinate Index

#xlwings

rng=sht.range(‘B2:D5’)

rng[0,0].select()    #B2，Note: The index is 0-based

#xlwings API

#rng=sht.api.Range(‘B2:D5’)

#rng(1,1).Select()

Linear Index

#xlwings

#rng=sht.range(‘B2:D5’)

#rng[2].select()

#xlwings API

#rng=sht.api.Range(‘B2:D5’)

# rng(3).Select()

Slicing

#xlwings

#rng=sht.range(‘B2:D5’)

#rng[1:3,1:3].select()    #Slicing C3:D4

#rng[:,2].select()     #Slicing  D2:D5

Sample Code

#Referencing Cells Within a Range

import xlwings as xw    #Import the xlwings package

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

#Coordinate Index
#xlwings
rng=sht.range('B2:D5')
rng[0,0].select()    #B2，Note: The index is 0-based

#xlwings API
#rng=sht.api.Range('B2:D5')
#rng(1,1).Select()

#Linear Index
#xlwings
#rng=sht.range('B2:D5')
#rng[2].select()

#xlwings API
#rng=sht.api.Range('B2:D5')
# rng(3).Select()

#Slicing
#xlwings
#rng=sht.range('B2:D5')
#rng[1:3,1:3].select()    #Slicing C3:D4
#rng[:,2].select()     #Slicing  D2:D5

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