title: How to read only visible sheets from Excel using Pandas?
body: <p>I have to get some random Excel sheets where I want to <strong>read only visible sheets</strong> from those files.</p>
  
  <p>Consider one file at a time, let's say I have <code>Mapping_Doc.xls</code> which contains 2-visible sheets and 2-hidden sheets. </p>
  
  <p>As the sheets are less here, I can parse them with names like this:</p>
  
  <p>Code :</p>
  
  <pre><code>xls = pd.ExcelFile('D:\\ExcelRead\\Mapping_Doc.xls')
  print xls.sheet_names
  df1 = xls.parse('Sheet1') #visible sheet
  df2 = xls.parse('Sheet2') #visible sheet
  </code></pre>
  
  <p>Output: </p>
  
  <pre><code>[u'sheet1',u'sheet2',u'sheet3',u'sheet4']
  </code></pre>
  
  <p>How can I get only the visible sheets?</p>