import pandas
df = pandas.read_excel(open('your_xls_xlsx_filename', 'rb'), sheetname=
    'Sheet 1')
df = pandas.read_excel(open('your_xls_xlsx_filename', 'rb'), sheetname=2)
Reading an Excel file in python using pandas