How To Define Cell Names Using xlwings?

Method

Cells

#xlwings

cl=sht.cells(3,3)

#cl.name=’test’

#sht.range(‘test’).select()

#xlwings API

#cl=sht.api.Range(‘C3’)

#cl.Name=’test’

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

Cell ranges

#xlwings

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

#cl.name =’MyData’

#sht.range(‘MyData’).select()

#xlwings API

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

#cl.Name =’MyData’

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

Sample Code

#Cell Names

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

#Cells
#xlwings
cl=sht.cells(3,3)
cl.name='test'
sht.range('test').select()

#xlwings API
#cl=sht.api.Range('C3')
#cl.Name='test'
#sht.api.Range('test').Select()

#Cell ranges
#xlwings
#cl =sht.range('A3:C8')
#cl.name ='MyData'
#sht.range('MyData').select()

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

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