Using R to read out excel-colorinfo
Answer recommended by R Language Collective
readxl
Read Excel file from a URL using the readxl package
This works for me on Windows: library(readxl) library(httr) packageVersion(“readxl”) # [1] ‘0.1.1’ GET(url1, write_disk(tf <- tempfile(fileext = “.xls”))) df <- read_excel(tf, 2L) str(df) # Classes ‘tbl_df’, ‘tbl’ and ‘data.frame’: 20131 obs. of 8 variables: # $ Code : chr “C115388” “C115800” “C115801” “C115802” … # $ Codelist Code : chr NA “C115388” “C115388” “C115388” … … Read more