title: How to load win32com Excel worksheet to Pandas df?
body: <p>I have the following code:</p>
  <pre><code>import pandas as pd
  import win32com.client
  
  excel_app = win32com.client.Dispatch(&quot;Excel.Application&quot;)
  file_path = r&quot;path to the file&quot;
  file_password = &quot;file password&quot;
  workbook = excel_app.Workbooks.Open(file_path, Password=file_password)
  sheet = workbook.Sheets(&quot;sheet name&quot;)
  </code></pre>
  <p>Now I'd like to take the sheet variable and load it into a Pandas df. I was trying to accomplish it via saving the sheet to a separate file and then reading it from Pandas, but it seems to be over-complicating the issue, as the file is both password protected and in .xlsm format, so re-opening it directly from Pandas isn't straightforward.</p>
  <p>How do I do it?</p>