How To Reference Offsets Constructed Cell Ranges Using xlwings?

Method

#xlwings

sht.range(‘A3:C8’).offset(1).select()     #A4:C9

#sht.range(‘A3:C8’).offset(0,1).select()     #B3:D8

#sht.range(‘A3:C8’).offset(1,1).select()     #B4:D9

#xlwings API

#sht.api.Range(sht.api.Range(‘A3’).Offset(2),sht.api.Range(‘C8’).Offset(2)).Select()     #A4:C9

#sht.api.Range(sht.api.Range(‘A3’).Offset(1,2),sht.api.Range(‘C8’).Offset(1,2)).Select()     #B3:D8

#sht.api.Range(sht.api.Range(‘A3’).Offset(2,2),sht.api.Range(‘C8’).Offset(2,2)).Select()     #B4:D9

Sample Code

#Reference an offset-constructed 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

#xlwings
sht.range('A3:C8').offset(1).select()     #A4:C9
#sht.range('A3:C8').offset(0,1).select()     #B3:D8
#sht.range('A3:C8').offset(1,1).select()     #B4:D9

#xlwings API
#sht.api.Range(sht.api.Range('A3').Offset(2),sht.api.Range('C8').Offset(2)).Select()     #A4:C9
#sht.api.Range(sht.api.Range('A3').Offset(1,2),sht.api.Range('C8').Offset(1,2)).Select()     #B3:D8
#sht.api.Range(sht.api.Range('A3').Offset(2,2),sht.api.Range('C8').Offset(2,2)).Select()     #B4:D9

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