Print the variables in your global scope in Python in Excel

pyexcel_print_globals.py

import inspect

begin_print = False
module_print = True
function_print = True

for key, value in list(globals().items()):
    if begin_print and not key.endswith("_print"):
        # print imported module names if requested
        if module_print and inspect.ismodule(value):
            print(f"module {key}")
        # print function definitions if requested
        elif callable(value) and function_print:
            print(f"{inspect.getsource(value).strip()}")
        # print other variables
        elif not inspect.ismodule(value) and not callable(value):
            print(f"{type(value).__name__} {key}={value}")
    # user variables appear after xl() in the global scope
    elif key == "xl" and callable(value):
        begin_print = True