Reading data from Excell with python | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Reading data from Excell with python

How can someone read and manipulate data from microsoft excel.

28th Aug 2020, 2:54 PM
Brian Muchai
Brian Muchai - avatar
2 Answers
+ 5
If you need to manipulate an excel sheet, you can use separate modules like xlwings from: https://www.xlwings.org/
28th Aug 2020, 3:21 PM
Lothar
Lothar - avatar
+ 3
Yes, use Pandas, df=pd.read_excel(PATH\FileName.xlsx) https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html
28th Aug 2020, 3:02 PM
Steven M
Steven M - avatar