title: UnicodeDecodeError: 'utf-16-le' codec can't decode byte 0x20 in position 108: truncated data
body: <p>I want to read an excel file using pandas but get the following error:</p>
  <pre><code>WARNING *** OLE2 inconsistency: SSCS size is 0 but SSAT size is non-zero
  --------------------------------------------------------------------------
  UnicodeDecodeError: 'utf-16-le' codec can't decode byte 0x20 in position 108: truncated data
  </code></pre>
  <p>Here's the code that produces the error:</p>
  <pre><code>if not os.path.exists(&quot;Raw_Data&quot;):
      os.mkdir(&quot;Raw_Data&quot;)
  path = 'Raw_Data' 
  all_files = glob.glob(path + &quot;/*.xls&quot;)
  
  li = []
  
  for filename in all_files:
      df_updated = pd.read_excel(filename, index_col=None, header=0)
      li.append(df_updated)
  </code></pre>
  <p>The file was exported to .xlsx from a .aspx internal server page.</p>
  <p>I've spent the morning troubleshooting to no avail - any suggestions on how to proceed?</p>