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

1 vote200 views1 answer
Pyinstaller for spacy code
Python
0 vote192 views1 answer
Exception Value: Object of type User is not JSON serializable
Python
1 vote193 views3 answers
Python find string count in str
Python
0 vote191 views1 answer
Instabot login python
Python
-1 vote189 views2 answers
Pandas print groupby
Python
0 vote199 views1 answer
How to save the command result with ! in python
Python
0 vote230 views1 answer
Min max code in python
Python
50 votes218 views1 answer
How to find item in list python without indexnig
Python
2 votes187 views1 answer
How to check if an element is visible on the web page in selenium python
Python
39 votes196 views2 answers
String to list of characters python
Python