excel - How to insert new row - xlwings -


what i'm trying achieve extend length of table within current excel form (not appending bottom of whole spreadsheet), while not replacing content below table.

to this, want insert new rows (for example on row 30). how can this xlwings?

i figured out how can done. unfortunately xlwings doesn't seem have functionality built in, it's possible using api.

this how inserted new row:

sht.range("30:30").api.insert(insertshiftdirection.xlshifttoright) 

Comments

Popular posts from this blog

python - Best design pattern for collection of objects -

android - IllegalStateException: Cannot call this method while RecyclerView is computing a layout or scrolling -

go - serving up pdfs using golang -