Use formulas instead of Power Query for tidy files, with a visible source path and clear parameters that teammates can review ...
openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files. It was born from lack of existing library to read/write natively from Python the Office Open XML format. All kudos to ...