How to read xlsm file in Python using Pandas

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


  Students  Scores
0    Harry      77
1     John      59
2  Hussain      88
3   Satish      93

Free Learning Resources

Leave a Comment

Your email address will not be published.