pythonexcelpython-3.xxlwings

How to set row height using Python xlwings

I have added new sheet to existing excel sheet using Python xlwings. I want to set row height to 15 in new sheet. How can I do that.?

Solution

  • As explained under Missing Features, you can always drop down to pywin32 and check out the documentation for VBA.

    In your case, it would work like this:

    import xlwings as xw
wb = xw.Book(...)
wb.sheets[0]['1:1'].api.RowHeight = 100