read_xlsx.py

import pandas as pd
from openpyxl import load_workbook
import urllib.request

local = False
if local:
    excel_file = r"C:\Users\rcxsm\Documents\python_scripts\streamlit_scripts\input\dummy_occupation.xlsx"
    wb = load_workbook(excel_file, data_only=True)
else:
    excel_file = r"https://github.com/rcsmit/streamlit_scripts/blob/main/input/dummy_occupation.xlsx?raw=true"
    urllib.request.urlretrieve(excel_file, "test.xlsx")
    wb = load_workbook("test.xlsx", data_only=True)
    
sh_2022 = wb["TEST"] # test is the sheetname