title: Reading Excel file into R using readxl and httr/libxls error: Unable to open file
body: <p>I'd like to read in sheet 1 of an Excel file from a website <a href="https://dataverse.harvard.edu/dataset.xhtml?persistentId=doi:10.7910/DVN/WEGWGS" rel="nofollow noreferrer">Link</a> using the url of the Excel file. I'm on windows 10, R 3.6.1. </p>
  
  <p>I'm trying to use the code from <a href="https://stackoverflow.com/questions/41368628/read-excel-file-from-a-url-using-the-readxl-package">Read Excel file from a URL using the readxl package</a> and have also checked out <a href="https://stackoverflow.com/questions/31165717/reading-excel-files-into-a-single-dataframe-with-readxl-r">reading excel files into a single dataframe with readxl R</a>. </p>
  
  <pre><code>url = 'https://dataverse.harvard.edu/file.xhtml?  persistentId=doi:10.7910/DVN/WEGWGS/I11K9Y&amp;version=1.0'
  GET(url, write_disk(tf &lt;- tempfile(fileext = ".xls")))
  df &lt;- read_excel(tf, 1L)
  
  
  # Error message
  libxls error: Unable to open file
  </code></pre>
  
  <p><strong>I get the following error message:</strong> </p>
  
  <blockquote>
    <p>libxls error: Unable to open file</p>
  </blockquote>
  
  <p>Thanks for any help!</p>