load excel

import pandas as pd
df = pd.read_excel (r'D:\Python_Test.xlsx')
#for an earlier version of Excel, you may need to use the file extension of 'xls'
lines = df.values
cols = df.columns
for i in cols:
     print(i)
for i in lines:
     print(i)