title: XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'\r\n\r\n<!--'
body: <p>I currently am using python to interpret and add to data stored in xlsx files.  I am attempting to store the data in SharePoint, but am unable to use the information.  When I run the following request, I get <code>Out[6]: &lt;Response [200]&gt;</code>, so I know it responded to the request.</p>
  <pre><code>import requests
  import json
  from json import loads
  import pandas as pd
  from requests_negotiate_sspi import HttpNegotiateAuth
  headers={&quot;User-Agent&quot;:&quot;Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.77 Safari/537.36&quot;}
  requests.get('OneDrive file address',auth=HttpNegotiateAuth(),headers=headers)
  </code></pre>
  <p>However, I have tried multiple methods to put this data in a Pandas data frame, and every time have face difficulty.  When I attempted to convert to JSON, I would get the same error: <code>JSONDecodeError: Expecting value: line 3 column 1 (char 4)</code>.  Most of the solutions I found were for line 1 column 1 (char 0) and did not work for mine.  This is one of the methods I tried to convert.</p>
  <pre><code>import requests
  import json
  from json import loads
  import pandas as pd
  from requests_negotiate_sspi import HttpNegotiateAuth
  headers={&quot;User-Agent&quot;:&quot;Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.77 Safari/537.36&quot;}
  tern=requests.get('One Drive Address',auth=HttpNegotiateAuth(),headers=headers)
  tern_dict=tern.json()
  db=pd.DataFrame.from_dict(tern_dict)
  print(db)
  </code></pre>
  <p>The other main error I've been getting is when I tried to directly treat the file like an excel file: <code>XLRDError: Unsupported format, or corrupt file: Expected BOF record; found b'\r\n\r\n&lt;!--'</code>
  This would be done by using something similar to</p>
  <pre><code>import requests
  import json
  from json import loads
  import pandas as pd
  from requests_negotiate_sspi import HttpNegotiateAuth
  headers={&quot;User-Agent&quot;:&quot;Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.77 Safari/537.36&quot;}
  tern=requests.get('One Drive Address',auth=HttpNegotiateAuth(),headers=headers)
  df=pd.read_excel(tern)
  </code></pre>
  <p>I tried to run <code>df=pd.read_html(tern)</code> instead, but the error is <code>ValueError: No tables found</code>.</p>
  <p>How do I make this function so that I can work with the data?  In my initial version, I simply used <code>open()</code> on a local file and ran a <code>for</code> loop over each row of data, so I want to be able to do this with online file, so that multiple users are accessing the same information source.  I am sorry if any of this is unclear, I am still fairly new to programming this in-depth.</p>