Skip to content
import pandas as pd
import glob

data = pd.DataFrame()

filenames = glob.glob("*.xlsx")


for file in filenames:
   df = pd.concat(pd.read_excel(file, sheet_name=None), ignore_index=True, sort=False)
   data = data.append(df, ignore_index=True)
print(data)
TotalOrders = len(data.Order)
print (TotalOrders)