title: How to read Excel Workbook (pandas)
body: <p>First I want to say that I am not an expert by any means. I am versed but carry a burden of schedule and learning Python like I should have at a younger age!</p>
  
  <p>Question:<br>
  I have a workbook that will on occasion have more than one worksheet. When reading in the workbook I will not know the number of sheets or their sheet name. The data arrangement will be the same on every sheet with some columns going by the name of 'Unnamed'. The problem is that everything I try or find online uses the pandas.ExcelFile to gather all sheets which is fine but i need to be able to skips 4 rows and only read 42 rows after that and parse specific columns. Although the sheets might have the exact same structure the column names might be the same or different but would like them to be merged.</p>
  
  <p>So here is what I have:</p>
  
  <pre><code>import pandas as pd
  from openpyxl import load_workbook
  
  # Load in the file location and name
  cause_effect_file = r'C:\Users\Owner\Desktop\C&amp;E Template.xlsx'
  
  # Set up the ability to write dataframe to the same workbook
  book = load_workbook(cause_effect_file)
  writer = pd.ExcelWriter(cause_effect_file) 
  writer.book = book
  writer.sheets = dict((ws.title, ws) for ws in book.worksheets)
  
  # Get the file skip rows and parse columns needed
  xl_file = pd.read_excel(cause_effect_file, skiprows=4, parse_cols = 'B:AJ', na_values=['NA'], convert_float=False)
  
  # Loop through the sheets loading data in the dataframe
  dfi = {sheet_name: xl_file.parse(sheet_name)
            for sheet_name in xl_file.sheet_names}
  
  # Remove columns labeled as un-named
  for col in dfi:
      if r'Unnamed' in col:
          del dfi[col]
  
  # Write dataframe to sheet so we can see what the data looks like
  dfi.to_excel(writer, "PyDF", index=False)
  
  # Save it back to the book
  writer.save()
  </code></pre>
  
  <p>The link to the file i am working with is below
  <a href="https://www.dropbox.com/s/mrt8pe3v9hes0nz/c%26e%20template.xlsx?dl=0" rel="nofollow">Excel File</a></p>