title: R Web scrape Excel spreadsheet URLs to read with openxlsx
body: <p>I need to read parts of an Excel file into R. I have some existing code, but the authority changed the source. Previously, there was a direct URL to the document, now the link to the document can only be accessed through a website landing page. </p>
  
  <p>Could someone tell me with which package I can achieve that? The link to the Excel file is: <a href="http://www.snamretegas.it/it/business-servizi/dati-operativi-business/8_dati_operativi_bilanciamento_sistema/" rel="nofollow noreferrer">http://www.snamretegas.it/it/business-servizi/dati-operativi-business/8_dati_operativi_bilanciamento_sistema/</a> 
  There i am looking at the document: "Dati operativi relativi al bilanciamento del sistema post Del. 312/2016/R/gas - Database 2018"</p>
  
  <p>I add the previous code to give an idea what I did. As you can see, I only required read.xlsx for this first step.  </p>
  
  <p>Many thanks in advance!</p>
  
  <pre><code>  library(ggplot2)
    library(lubridate)
    library(openxlsx)
    library(reshape2)
    library(dplyr)
  
    Bilres &lt;- read.xlsx(xlsxFile = "http://www.snamretegas.it/repository/file/Info-storiche-qta-gas-trasportato/dati_operativi/2017/DatiOperativi_2017-IT.xlsx",sheet = "Storico_G", startRow = 1, colNames = TRUE)
  
  
    # Selecting Column R from Storico_G and stored in variable Bilres_df
  
    Bilres_df &lt;- data.frame(Bilres$pubblicazione, Bilres$BILANCIAMENTO.RESIDUALE )
  
    # Conerting pubblicazione in date format and time
    Bilres_df$pubblicazione &lt;- ymd_h(Bilres_df$Bilres.pubblicazione)
    Bilreslast=tail(Bilres_df,1)
    Bilreslast=data.frame(Bilreslast)
    Bilreslast$Bilres.BILANCIAMENTO.RESIDUALE &lt;- as.numeric(as.character((Bilreslast$Bilres.BILANCIAMENTO.RESIDUALE)))
  </code></pre>