Python read xls

# credit to Stack Overflow user in the source link

import pandas as pd

# use r before absolute file path
xls = pd.ExcelFile(r"yourfilename.xls")  

# 2 is the sheet number+1 thus 
# if the file has only 1 sheet write 0 in paranthesis
sheetX = xls.parse(2) 
var1 = sheetX['ColumnName']

# 1 is the row number
print(var1[1])

Source: stackoverflow.com

Similar codes

4 votes209 views1 answer
Django objects.create()
Python Django
2 votes206 views1 answer
Python how to unnest a nested list
Python
1 vote179 views2 answers
Crop image using opencv with height and width
Python
0 vote174 views1 answer
How to read xlsx file from one directory above python
Python
0 vote174 views1 answer
Getting the Current Working Directory in Python
Python
1 vote178 views2 answers
File C:\Users\7shal\PycharmProjects\Itsa Me Malario\main.py, line 2 from pygame.locals import import ^ SyntaxError: invalid syntax
Python
0 vote193 views2 answers
Get min of list python
Python
0 vote197 views1 answer
Python print \n every n loops
Python
0 vote215 views1 answer
Python collections to dictionary
Python
0 vote203 views1 answer
Group by, aggregate multiple column -pandas
Python