title: pd.read_excel can't read xlsm file
body: <p>I use  below code to read xlsm file: </p>
  
  <p><code>df = pd.read_excel(filepath,target_worksheet)</code> </p>
  
  <p>but it doesn't work, the error message is:<br>
  <code>XLRDError: Can't find workbook in OLE2 compound document</code>. </p>
  
  <p>Pandas official website mentions that it supports xlsm file,  as <a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html" rel="nofollow noreferrer">link</a>. I am wondering whether my conclusion is correct or not.</p>
  
  <p>Then I use win32com , which can open the excel file and extract the data for cells, but it seems that it can't be read as DataFrames. </p>
  
  <p>Is there any solution to read xlsm file to DataFrame?
  Thanks.</p>
  
  <p>Thank you.</p>