You can read the XLS file in Python using Pandas with the following code. I highly recommend you This book to learn Python.
Read XLS File
# Import the Pandas libraray as pd import pandas as pd # Read xls file df = pd.read_excel("score.xls",sheet_name='Sheet1') # Display the Data print(df)
Students Score Grade 0 Harry 93 A 1 Richard 80 B 2 Hussain 70 C 3 Satish 85 B 4 Ali 76 C 5 Messi 99 A