How To Select Rows and Columns Using xlwings?

Method

#Select a single row

#xlwings

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

 

#xlwings API

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

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

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

 

#Select multiple consecutive rows

#xlwings

#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:A5’).EntireRow.Select()

 

#Select multiple non-consecutive rows

#xlwings

#sht.range(‘1:5,7:10’).select()

 

#xlwings API

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

 

#————————-

 

#Select a single column

#xlwings

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

 

#xlwings API

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

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

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

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

 

#Select multiple consecutive 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()

 

#Select multiple non-consecutive columns

#xlwings

#sht.range(‘C:E,G:I’).select()

 

#xlwings API

#sht.api.Range(‘C:E,G:I’).Select()

Sample Code

#Selecting Rows and Columns

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

#Select a single row
#xlwings
sht['1:1'].select()

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

#Select multiple consecutive rows
#xlwings
#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:A5').EntireRow.Select()

#Select multiple non-consecutive rows
#xlwings
#sht.range('1:5,7:10').select()

#xlwings API
#sht.api.Range('1:5,7:10').Select()

#-------------------------

#Select a single column
#xlwings
#sht.range('A:A').select()

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

#Select multiple consecutive 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()

#Select multiple non-consecutive columns
#xlwings
#sht.range('C:E,G:I').select()

#xlwings API
#sht.api.Range('C:E,G:I').Select()

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