title: How to count the total number of sheets in an Excel file using Python
body: <p>I am reading a excel file using python.</p>
  
  <pre><code>import pandas as pd
  import os
  
  xls = pd.ExcelFile('D:\DirectoryProject\Mapping.xlsx')
  </code></pre>
  
  <p>It has several number of data sheets which I don't know. How can I count the total number of sheets in <code>Mapping.xlsx</code> file using Python?</p>