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 vote119 views1 answer
How To Generate The Requirements Of Your Python Project Based On Your Imports
Python
6 votes123 views2 answers
Python check if folder is empty
Python
3 votes113 views2 answers
Find number of vowels in string python
Python
0 vote120 views1 answer
Pandas difference between subsequent lines
Python
5 votes99 views1 answer
How to make a sigmoid function in python
Python
20 votes107 views6 answers
Drop a column from dataframe
Python
3 votes99 views2 answers
Multiple variable input in python
Python
24 votes114 views6 answers
Static files in django
Python
3 votes113 views1 answer
Py change background
Python
1 vote123 views1 answer
Python return specific elements from list
Python