read excel and import headers as colms code example
Example: pandas read excel with two headers
df_dict = pandas.read_excel('ExcelFile.xlsx', header=[0, 1], sheetname=None)
df_dict = pandas.read_excel('ExcelFile.xlsx', header=[0, 1], sheetname=None)