title: Read Excel file from a URL using the readxl package
body: <p>Consider a file on the internet (like this one (note the s in https) <a href="https://evs.nci.nih.gov/ftp1/CDISC/SDTM/SDTM%20Terminology.xls" rel="noreferrer">https://evs.nci.nih.gov/ftp1/CDISC/SDTM/SDTM%20Terminology.xls</a></p>
  
  <p>How can the sheet 2 of the file be read into R?</p>
  
  <p>The following code is approximation of what is desired (but fails)</p>
  
  <pre><code>url1&lt;-'https://evs.nci.nih.gov/ftp1/CDISC/SDTM/SDTM%20Terminology.xls'
  p1f &lt;- tempfile()
  download.file(url1, p1f, mode="wb")
  p1&lt;-read_excel(path = p1f, sheet = 2)
  </code></pre>