gistfile1.txt

import pandas as pd

# to read just one sheet to dataframe:
A = pd.read_excel(file_name, sheetname="sheet1")
B = pd.read_excel(file_name, sheetname="sheet2")

print(A.columns)
print(B.columns)

Output:
  
Index(['Unknown_sample_no', 'Unknown_sample_seq'], dtype='object')
Index(['Reference_sequences_ID', 'Reference_sequences'], dtype='object')