Blog

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()

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()

How To Reference General Cell Ranges Using xlwings?

Method

#xlwings

sht.range(‘A3:C8’).select()    #Select the cell range A3:C8

#sht.range(‘A3′,’C8’).select()

#sht.range(sht.range(‘A3’),sht.range(‘C8’)).select()

#sht.range(sht.cells(3,1),sht.cells(8,3)).select()

#sht.range((3,1),(8,3)).select()

 

#xlwings API

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

#sht.api.Range(‘A3′,’C8’).Select()

#sht.api.Range(sht.api.Range(‘A3’), sht.api.Range(‘C8’)).Select()

#sht.api.Range(sht.api.Cells(3,1),sht.api.Cells(8,3)).Select()

Sample Code

#Referencing a General Range of Cells

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').select()    #Select the cell range A3:C8
#sht.range('A3','C8').select()
#sht.range(sht.range('A3'),sht.range('C8')).select()
#sht.range(sht.cells(3,1),sht.cells(8,3)).select()
#sht.range((3,1),(8,3)).select()

#xlwings API
#sht.api.Range('A3:C8').Select()
#sht.api.Range('A3','C8').Select()
#sht.api.Range(sht.api.Range('A3'), sht.api.Range('C8')).Select()
#sht.api.Range(sht.api.Cells(3,1),sht.api.Cells(8,3)).Select()

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

How To Reference Entire Columns Using xlwings?

Method

Single Column

#xlwings

sht.range(‘A:A’).select()    #Column 1

 

#xlwings API

#sht.api.Columns(1).Select()

#sht.api.Columns(‘A’).Select()

#sht.api.Range(‘A:A’).Select()

#sht.api.Range(‘A1’).EntireColumn.Select()

 

Multiple Columns

#xlwings

#sht.range(‘B:C’).select()

#sht[:,1:3].select()

 

#xlwings API

#sht.api.Columns(‘B:C’).Select()

#sht.api.Range(‘B:C’).Select()

#sht.api.Range(‘B1:C2’).EntireColumn.Select()

Sample Code

#Referencing an Entire Column

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

#Single Column
#xlwings
sht.range('A:A').select()    #Column 1

#xlwings API
#sht.api.Columns(1).Select()
#sht.api.Columns('A').Select()
#sht.api.Range('A:A').Select()
#sht.api.Range('A1').EntireColumn.Select()

#Multiple Columns
#xlwings
#sht.range('B:C').select()
#sht[:,1:3].select()

#xlwings API
#sht.api.Columns('B:C').Select()
#sht.api.Range('B:C').Select()
#sht.api.Range('B1:C2').EntireColumn.Select()

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

How To Reference Entire Rows Using xlwings?

Method

Single Row

#xlwings

sht.range(‘1:1’).select()     #Row 1

#sht[‘1:1’].select()

 

#xlwings API

#sht.api.Rows(1).Select()

#sht.api.Range(‘1:1’).Select()

#sht.api.Range(‘A1’).EntireRow.Select()

 

Multiple Rows

#xlwings

#sht.range(‘1:5’).select()    #Rows 1–5

#sht[‘1:5’].select()

#sht[0:5,:].select()

 

#xlwings API

#sht.api.Rows(‘1:5’).Select()

#sht.api.Range(‘1:5’).Select()

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

Sample Code

#Referencing an Entire Row

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

#Single Row
#xlwings
sht.range('1:1').select()     #Row 1
#sht['1:1'].select()

#xlwings API
#sht.api.Rows(1).Select()
#sht.api.Range('1:1').Select()
#sht.api.Range('A1').EntireRow.Select()

#Multiple Rows
#xlwings
#sht.range('1:5').select()    #Rows 1–5
#sht['1:5'].select()
#sht[0:5,:].select()

#xlwings API
#sht.api.Rows('1:5').Select()
#sht.api.Range('1:5').Select()
#sht.api.Range('A1:C5').EntireRow.Select()

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

How To Reference Cells with Variables Using xlwings?

Method

#xlwings

i=3    #Create a variable `i`

sht.range(“C”+ str(i)).select()    #Reference a cell using the variable `i`

#sht.cells(i,i).select()

 

#xlwings API

#i=3

#sht.api.Range(“C”+ str(i)).Select()

#sht.api.Cells(i,i).Select()

Sample Code

#Referencing Cells Using Variables

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
i=3    #Create a variable `i`
sht.range("C"+ str(i)).select()    #Reference a cell using the variable `i`
#sht.cells(i,i).select()

#xlwings API
#i=3
#sht.api.Range("C"+ str(i)).Select()
#sht.api.Cells(i,i).Select()

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

How To Reference Cells by Name Using xlwings?

Method

#xlwings

cl=sht.cells(3,3)

cl.name=’test’    #Setting the cell name

sht.range(‘test’).select()    #Referencing the cell by it’s name

 

#xlwings API

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

#cl.Name=’test’

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

Sample Code

#Referencing by Cell 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.cells(3,3)
cl.name='test'    #Setting the cell name
sht.range('test').select()    #Referencing the cell by it's name

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

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

How To Reference Multiple Cells Using xlwings?

Method

#xlwings

sht.range(‘B2, C5, D7’).select()

#sht[‘B2, C5, D7’].select()

 

#xlwings API

#sht.api.Range(‘B2, C5, D7’).Select()

Sample Code

#Referencing Multiple Cells

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('B2, C5, D7').select()
#sht['B2, C5, D7'].select()

#xlwings API
#sht.api.Range('B2, C5, D7').Select()

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

How To Reference a Single Cell Using xlwings?

Method

#xlwings

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

#sht.range(1,1).select()

#sht[‘A1’].select()

#sht.cells(1,1).select()

#sht.cells(1,’A’).select()

 

#xlwings API

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

#sht.api.Cells(1, ‘A’).Select()

#sht.api.Cells(1,1).Select()

Sample Code

#Referencing a Single Cell

import xlwings as xw    #Import the xlwings package

bk=xw.Book()
sht=bk.sheets.active    #Get the active worksheet

#xlwings
sht.range('C3').select()
#sht.range(3,3).select()
#sht['C3'].select()
#sht.cells(3,3).select()
#sht.cells(3,'C').select()

#xlwings API
#sht.api.Range('C3').Select()
#sht.api.Cells(3, 'C').Select()
#sht.api.Cells(3,3).Select()

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