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

6 votes152 views2 answers
Show all columns pandas jupyter notebook
Python
0 vote128 views1 answer
Set pytesseract cmd path
Python
0 vote125 views1 answer
How to generate python code
Python
17 votes161 views6 answers
How to join two lists in python
Python
10 votes140 views1 answer
Pandas select by column value
Python
1 vote139 views1 answer
How to convert string to int in python
Python
0 vote125 views1 answer
Numpy symmetrize array
Python
0 vote126 views1 answer
String list into list pandas
Python
40 votes135 views6 answers
Count nan pandas
Python
0 vote141 views1 answer
Python : a counter
Python