DEV Community

Muthu
Muthu

Posted on

3 2

Read Excel sheet using Pandas

import pandas as pd

EXCEL_FILE = 'source.xlsx'

df= pd.read_excel(open(EXCEL_FILE, 'rb'),skiprows=3,index=False)

print(df)


Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay