How To Reference Cells by Name Range Using xlwings?

Method

#xlwings

cl = sht.range(‘A3:C8’)

cl.name = ‘MyData’    #Create a name

sht.range(‘MyData’).select()    #Reference by Name

#xlwings API

#cl = sht.api.Range(‘A3:C8’)

#cl.Name = ‘MyData’

#sht.api.Range(‘MyData’).Select()

Sample Code

#Reference a cell range by its name

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
cl = sht.range('A3:C8')
cl.name = 'MyData'    #Create a name
sht.range('MyData').select()    #Reference by Name

#xlwings API
#cl = sht.api.Range('A3:C8')
#cl.Name = 'MyData'
#sht.api.Range('MyData').Select()

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