Read XLSX file from url for R shiny app

[oktayozden]

I prepare R shiny dashboard. I want to read xlsx file from below link. How can i do that? It has to work after deployment.

https://github.com/oktayozden/R-shiny-COVID19Dashboard/raw/master/latlong.xlsx

[jupev]

Hi,
I don't know how to read an excel file from an url, but since it is only one sheet, saving it as csv might be the easiest solution.

For instance:

library(shiny)


url <- "https://github.com/Juliepvr/R-project/raw/master/hfi_cc_2018.csv"
hfi <- read.csv(url)


ui <- fluidPage(
  h2("Read CSV from url"),
  DTOutput("csv")
)

server <- function(input, output){
  output$csv <- renderDataTable({
    hfi
  })
}


shinyApp(ui = ui, server = server)

If it does have to be en excel file, maybe this topic on stackoverflow can be of use: https://stackoverflow.com/questions/41368628/read-excel-file-from-a-url-using-the-readxl-package