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 vote365 views2 answers
Stable version of django
Python
1 vote370 views2 answers
Python3 to python
Python
0 vote332 views1 answer
Additon of multiple duration timestamps python
Python
0 vote362 views1 answer
Django table view sort filter
Python Django
4 votes327 views1 answer
Round python with list
Python
0 vote337 views1 answer
All the positions of a letter occurrences in a string python
Python
0 vote368 views1 answer
Parquet pyspark
Python
0 vote314 views1 answer
Calculate volume of mask
Python
3 votes332 views1 answer
Python iterate letters
Python
1 vote433 views1 answer
Django queryset group by count
Python Django