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

0 vote124 views1 answer
How to select axis value in python
Python
0 vote121 views1 answer
Scatter matrix plot
Python
0 vote124 views2 answers
User logout in django rest framework
Python
0 vote118 views2 answers
Flask upload file to s3
Python
0 vote138 views1 answer
Cannot set `other` if drop=True
Python
0 vote118 views1 answer
Python check file format
Python
0 vote159 views1 answer
Django-mathfilters
Python Django
0 vote113 views1 answer
Calculate term frequency python
Python
12 votes121 views6 answers
How to Find Unique Values in a Column in Pandas
Python
28 votes131 views2 answers
Python string slicing
Python