xlwings: Delete a col | row from Excel

Question

How do I delete a row in Excel?

wb = xw.Book('Shipment.xlsx')
wb.sheets['Page1_1'].range('1:1').clear()

.clear() works to remove the content. I want to delete the row. I'm surprise the .clear() function works, but not .delete()

Any advice helps! Thank you

Answer 1

It is now possible to delete without using api property:

wb.sheets['Page1_1'].range('1:1').delete()