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)Output:
Students Scores 0 Harry 77 1 John 59 2 Hussain 88 3 Satish 93
