things can be done in excel using python code example

Example: read a function of excel in python

wb = load_workbook('file.xlsx', data_only=True)