import pandas as pd

df = pd.read_html('/$[ReconcileDate]/Detail_$[ReconcileDate].xls', header=0)

dff = pd.concat(df)

dff.columns = dff.columns.str.replace('[., ]','_')

dff.head()

out = spark.createDataFrame(dff.astype(str))

out.createOrReplaceTempView('BaseCode')