title: Append Multiple Excel Files(xlsx) together in python
body: <pre><code>import pandas as pd
  import os
  import glob
  
  
  all_data = pd.DataFrame()
  for f in glob.glob("output/test*.xlsx")
      df = pd.read_excel(f)
      all_data = all_data.append(df, ignore_index=True)
  </code></pre>
  
  <p>I want to put multiple xlsx files into one xlsx. the excel files are in the output/test folder. The columns are the same, in all but I want concat the rows. the above code doesn't seem to work</p>