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

2 votes318 views1 answer
Get guild from a channel discord py
Python
3 votes312 views4 answers
If or Python
Python
0 vote321 views1 answer
Converting (YYYY-MM-DD-HH:MM:SS) date time
Python
3 votes317 views2 answers
Is in python
Python
1 vote338 views1 answer
Django model choice field from another model
Python
0 vote321 views1 answer
Remove the secound to last veriable in a list python
Python
0 vote298 views1 answer
Binary to decimal python
Python
3 votes306 views2 answers
Discord.py edit messages
Python
0 vote336 views1 answer
Pandas set index integer not float
Python
1 vote311 views1 answer
Jpython
Python