Skip to content
My Workspace
  • AI Chat
  • Code
  • Report
  • 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)