update_readme.py

import pyexcel as p
from dotmap import DotMap

md_filename = "readme.md"
xlsx_name = "games.xlsx"
open_tag = "<!--GAMES_TABLE-->"
close_tag = "<!--GAMES_TABLE_END-->"
bgg_icon = "<img src=https://cf.geekdo-static.com/icons/favicon2.ico width=20>"
wiki_icon = """<img src="https://upload.wikimedia.org/wikipedia/commons/5/5a/Wikipedia's_W.svg" width=20>"""
# generic_icon = "<img src=https://upload.wikimedia.org/wikipedia/commons/2/25/External.svg width=20>"
generic_icon = "<img src=https://upload.wikimedia.org/wikipedia/commons/7/74/Internet-web-browser.svg width=20>"
games_page = "Games"


def linkicon(link):
    ico = generic_icon
    if "boardgamegeek" in link:
        ico = bgg_icon
    if "wikipedia" in link:
        ico = wiki_icon
    return f"[{ico}]({link})"


def jointopics(topic1, topic2):
    return f"{topic1}, {topic2}" if topic2 else f"{topic1}"


book = p.get_book(file_name=xlsx_name)
sheet = book[games_page]
cols = DotMap({name.replace(" ", ""): c for c, name in enumerate(sheet.row[0])})


r = "\n|Name|BGG Rating|Core LOC|GUI value|Players|Category|Topics|\n"
r += "|---|---|---|---|---|---|---|\n"

for row in list(sheet.rows())[1:]:
    r += f"|{linkicon(row[cols.BGG])}{linkicon(row[cols.AltLink])}&nbsp;"
    r += f"[{row[cols.Name]}](/{row[cols.Folder]}/readme.md)|"
    r += f"{row[cols.BGGRating]}|{row[cols.CoreLOC]}|{row[cols.GUIValue]}|{row[cols.Players]}|"
    r += f"{row[cols.Category]}|{jointopics(row[cols.Topic1], row[cols.Topic2])}|\n"


with open(md_filename, "r", encoding="utf-8") as f:
    mdfile = f.read()
    s_beg = mdfile[: mdfile.find(open_tag) + len(open_tag)]
    s_end = mdfile[mdfile.find(close_tag) :]


with open(md_filename, "wt", encoding="utf-8") as f:
    f.write(f"{s_beg}{r}\n{s_end}")