Read Excel file from a URL using the readxl package

by

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" ...
# $ Codelist Extensible (Yes/No): chr  "No" NA NA NA ...
# $ Codelist Name               : chr  "6 Minute Walk Functional Test Test Code" "6 Minute Walk Functional Test Test Code" "6 Minute Walk Functional Test Test Code" "6 Minute Walk Functional Test Test Code" ...
# $ CDISC Submission Value      : chr  "SIXMW1TC" "SIXMW101" "SIXMW102" "SIXMW103" ...
# $ CDISC Synonym(s)            : chr  "6 Minute Walk Functional Test Test Code" "SIXMW1-Distance at 1 Minute" "SIXMW1-Distance at 2 Minutes" "SIXMW1-Distance at 3 Minutes" ...
# $ CDISC Definition            : chr  "6 Minute Walk Test test code." "6 Minute Walk Test - Distance at 1 minute." "6 Minute Walk Test - Distance at 2 minutes." "6 Minute Walk Test - Distance at 3 minutes." ...
# $ NCI Preferred Term          : chr  "CDISC Functional Test 6MWT Test Code Terminology" "6MWT - Distance at 1 Minute" "6MWT - Distance at 2 Minutes" "6MWT - Distance at 3 Minutes" ...

More Related Contents:

  1. Using R to read out excel-colorinfo
  2. How can I generate a user password in R [closed]
  3. In R; I would like to do something in R rather than excel because excel can’t handle the calculation. In excel the calculation is: =A2+SUM($B$2:B2)
  4. How to plot intersecting ranges in Excel/R/Matlab [closed]
  5. How can I read multiple (excel) files into R? [duplicate]
  6. How to convert Excel date format to proper date in R
  7. Easy way to export multiple data.frame to multiple Excel worksheets
  8. Read all worksheets in an Excel workbook into an R list with data.frames
  9. Export data from R to Excel
  10. melt / reshape in excel using VBA?
  11. Is there an R function to reshape this data from long to wide?
  12. Is it possible to get the number of rows in a CSV file without opening it?
  13. How do you read a password protected excel file into r?
  14. Importing a big xlsx file into R?
  15. How do I modify an existing a sheet in an Excel Workbook using Openxlsx package in R?
  16. Frequency counts in R [duplicate]
  17. Efficient way to rbind data.frames with different columns
  18. Change bar plot colour in geom_bar with ggplot2 in r
  19. Lattice: multiple plots in one window?
  20. What are the differences between “=” and “
  21. Escaping backslash (\) in string or paths in R
  22. define $ right parameter with a variable in R [duplicate]
  23. R: data.table cross-join not working
  24. eval and quote in data.table
  25. ggplot2: How to specify multiple fill colors for points that are connected by lines of different colors
  26. Writing multiple data frames into .csv files using R
  27. Converting factors to binary in R
  28. Return df with a columns values that occur more than once [duplicate]
  29. Generate ggplot2 boxplot with different colours for multiple groups
  30. Color points with the color as a column in ggplot2 [duplicate]

Leave a Comment