Read Excel file from a URL using the readxl package
<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>