You can read the XLSM file in Python using Pandas with the following code. I highly recommend you This book to learn Python.
Read XLSM File
# Import the Pandas libraray as pd import pandas as pd # Read xlsm file df = pd.read_excel("score.xlsm",sheet_name='Sheet1',index_col=0) # Display the Data print(df)
Students Scores 0 Harry 77 1 John 59 2 Hussain 88 3 Satish 93