pip install xlrd
pip install openpyxl
import xlrd
excel_sheet = xlrd.open_workbook('demo.xls')
sheet_one = excel_sheet.sheet_by_name('one')
print excel_sheet.sheet_names()
curr_row_index = 0
max_rows = sheet_one.nrows
max_cols = sheet_one.ncols
while curr_row_index < max_rows:
curr_col_index = 0
while curr_col_index < max_cols:
value = sheet_one.row(curr_row_index,curr_col_index)
curr_row_index+=1