How To Insert Rows and Columns Using xlwings?

Method

Row

#xlwings

sht.range(‘A2’).color=(0,255,0)

#sht.range(‘C2’).color=(0,0,255)

#sht.range(‘E2’).color=(255,0,0)

#sht[‘3:3′].insert(shift=’down’,copy_origin=’format_from_left_or_above’)

#xlwings API

#sht.api.Range(‘A2’).Interior.Color=xw.utils.rgb_to_int((0, 255, 0))

#sht.api.Range(‘C2’).Interior.Color=xw.utils.rgb_to_int((0, 0, 255))

#sht.api.Range(‘E2’).Interior.Color=xw.utils.rgb_to_int((255, 0, 0))

#sht.api.Rows(3).Insert(Shift=xw.constants.InsertShiftDirection.xlShiftDown,CopyOrigin=xw.constants.InsertFormatOrigin.xlFormatFromLeftOrAbove)

Column

#xlwings

#sht[‘B:B’].insert()

#xlwings API

#sht.api.Columns(2).Insert()

Sample Code

# Insert 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
sht.range('A2').color=(0,255,0)
sht.range('C2').color=(0,0,255)
sht.range('E2').color=(255,0,0)
sht['3:3'].insert(shift='down',copy_origin='format_from_left_or_above')

#xlwings API
#sht.api.Range('A2').Interior.Color=xw.utils.rgb_to_int((0, 255, 0))
#sht.api.Range('C2').Interior.Color=xw.utils.rgb_to_int((0, 0, 255))
#sht.api.Range('E2').Interior.Color=xw.utils.rgb_to_int((255, 0, 0))
#sht.api.Rows(3).Insert(Shift=xw.constants.InsertShiftDirection.xlShiftDown,CopyOrigin=xw.constants.InsertFormatOrigin.xlFormatFromLeftOrAbove)

#Column
#xlwings
#sht['B:B'].insert()

#xlwings API
#sht.api.Columns(2).Insert()

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