In Power Query Editor, select the query of the table with the blank rows and columns. set_default_row (hide_unused_rows = True) # Set the height of empty rows that we do want to display even if it is # the default height.
Xlwings delete empty rows As default value of inPlace is false, so contents of dfObj will not be modified.
