find_fill_color.py

def find_fill_color(cell):
    """Find fill color of a cell.
    Hulproutine, wordt niet aangeroepen in het script

    # dirty solution to find the fill color.
    # as solutions given here https://stackoverflow.com/questions/58429823/getting-excel-cell-background-themed-color-as-hex-with-openpyxl
    # dont work

    Args:
        cell (string): The cell you want to find the color from
    """

    val = sh_2022[cell].fill.start_color.rgb

    try:
        valx = val[0]
        valx = val
    except:
        valx = sh_2022[cell].fill.start_color.theme

    theme = sh_2022[cell].fill.start_color.theme
    tint = sh_2022[cell].fill.start_color.tint
    st.write(f"Valx = {valx  } | Theme = {theme} ||Tint = {tint}")