def add_worksheet_table(worksheet: Worksheet,
table_name: str,
col: int,
row: int,
start_col: int = ord('A'),
start_row: int = 1) -> None:
"""Adds table formatting to a worksheet
Col and Row are the table limits
:param worksheet:
:param table_name:
:param col:
:param row:
:param start_col:
:param start_row:
"""
tab = Table(displayName=table_name,
ref='{}{}:{}{}'.format(column_format(start_col), start_row,
column_format(col), row))
worksheet.add_table(tab)
