title: Looping through multiple excel files in python using pandas
body: <p>I know this type of question is asked all the time. But I am having trouble figuring out the best way to do this.</p>
  
  <p>I wrote a script that reformats a single excel file using <strong>pandas</strong>. 
  It works great.</p>
  
  <p>Now I want to loop through <strong>multiple</strong> excel files, preform the same reformat, and place the newly reformatted data from each excel sheet at the bottom, one after another.</p>
  
  <p>I believe the first step is to make a list of all excel files in the directory.
  There are so many different ways to do this so I am having trouble finding the best way.</p>
  
  <p>Below is the code I currently using to import multiple .xlsx and create a list.</p>
  
  <pre><code>import os
  import glob
  
  os.chdir('C:\ExcelWorkbooksFolder')
  for FileList in glob.glob('*.xlsx'):
           print(FileList)
  </code></pre>
  
  <p>I am not sure if the previous glob code actually created the list that I need.</p>
  
  <p>Then I have trouble understanding where to go from there.
  The code below fails at <code>pd.ExcelFile(File)</code>
  I beleive I am missing something....</p>
  
  <pre><code># create for loop
  for File in FileList:
      for x in File:
  # Import the excel file and call it xlsx_file
  xlsx_file = pd.ExcelFile(File)
  xlsx_file
  # View the excel files sheet names
  xlsx_file.sheet_names
  # Load the xlsx files Data sheet as a dataframe
  df = xlsx_file.parse('Data',header= None)
  # select important rows,
  df_NoHeader = df[4:]
  #then It does some more reformatting.
  '
  </code></pre>
  
  <p>Any help is greatly appreciated</p>