read excel file spyder

Do you want to know the information about “read excel file spyder”. If yes, you’re in the correct post.

read excel file spyder

import pandas as pd

df = pd.read_excel (r'Path where the Excel file is stored\File name.xlsx', sheet_name="your Excel sheet name")
print (df)
import pandas as pd

df = pd.read_excel (r'C:\Users\Ron\Desktop\Product List.xlsx') #place "r" before the path string to address special character, such as '\'. Don't forget to put the file name at the end of the path + '.xlsx'
print (df)

Final Thoughts

I hope this tutorial helps you to know about “read excel file spyder”. If you have any doubts regarding this article please let us know via the comment section. Share this tutorial with your friends and family via social networks.

Hi, I'm Ranjith a full-time Blogger, YouTuber, Affiliate Marketer, & founder of Coder Diksha. Here, I post about programming to help developers.

Share on:

Leave a Comment