title: How to get Excel active sheet name in Python/Pandas?
body: <p>I'm processing Excel file with multiple sheets via Pandas (read_excel) and need to get the name of the active sheet. Active sheet contains most recent data and the name convention is subject to "creator's mood". So I cannot use simple reading a sheet by name or index... Is there a way how to do it? </p>
  
  <p><strong>UPDATE (solution):</strong>
  Except xlrd with sheet_visible property proposed in Eswar's link (thank you) I discovered another solution with usage of xlwings library:</p>
  
  <pre><code>import xlwings as xw
  wb = xw.Book('myfile.xls')
  active_sheet_name = wb.sheets.active.name
  </code></pre>
  
  <p>=> Python is almighty...in many ways ;)  </p>