title: Pandas read_excel() with multiple sheets and specific columns
body: <p>I'm trying to use <code>pandas.read_excel()</code> to import multiple worksheets from a spreadsheet.  If I do not specify the columns with the parse_cols keyword I'm able to get all the data from the sheets, but I can't seem to figure out how to specify specific columns for each sheet.</p>
  
  <pre><code>import pandas as pd
  
  workSheets = ['sheet1', 'sheet2', 'sheet3','sheet4']
  cols = ['A,E','A,E','A,C','A,E']
  
  df = pd.read_excel(excelFile, sheetname=workSheets, parse_cols='A:E')  #This works fine
  df = pd.read_excel(excelFile, sheetname=workSheets, parse_cols=cols) #This returns empty dataFrames
  </code></pre>
  
  <p>Does anyone know if there is a way, using read_excel(), to import multiple worksheets from excel, but also specify specific columns based on which worksheet?</p>
  
  <p>Thanks.</p>