How To Copy/Cut Rows and Columns Using xlwings?

Method

Row

#xlwings API

sht.api.Rows(‘2:2’).Copy()

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

#sht.api.Paste()

#sht.api.Rows (‘2:3’).Select()

#bk.selection.api.Cut()

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

#sht.api.Paste()

Column

#sht.api.Columns(‘A:A’).Copy()

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

#sht.api.Paste()

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

#bk.selection.api.Cut()

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

#sht.api.Paste()

Sample Code

#Copying/Cutting 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

#Row
#xlwings API
sht.api.Rows('2:2').Copy()
sht.api.Range('A7').Select()
sht.api.Paste()

#sht.api.Rows ('2:3').Select()
#bk.selection.api.Cut()
#sht.api.Range('A7').Select()
#sht.api.Paste()

#Column
#sht.api.Columns('A:A').Copy()
#sht.api.Range('E1').Select()
#sht.api.Paste()

#sht.api.Columns('B:C').Select()
#bk.selection.api.Cut()
#sht.api.Range('F1').Select()
#sht.api.Paste()

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