Read an Excel file directly from a R script

by

Let me reiterate what @Chase recommended: Use XLConnect.

The reasons for using XLConnect are, in my opinion:

  1. Cross platform. XLConnect is written in Java and, thus, will run on Win, Linux, Mac with no change of your R code (except possibly path strings)
  2. Nothing else to load. Just install XLConnect and get on with life.
  3. You only mentioned reading Excel files, but XLConnect will also write Excel files, including changing cell formatting. And it will do this from Linux or Mac, not just Win.

XLConnect is somewhat new compared to other solutions so it is less frequently mentioned in blog posts and reference docs. For me it’s been very useful.

More Related Contents:

  1. Export data from R to Excel
  2. “Out of Memory Error (Java)” when using R and XLConnect package
  3. Write from R into template in excel while preserving formatting
  4. How to join (merge) data frames (inner, outer, left, right)
  5. Why are these numbers not equal?
  6. Select rows from a data frame based on values in a vector
  7. Issue when passing variable with dollar sign notation ($) to aes() in combination with facet_grid() or facet_wrap()
  8. Round up from .5
  9. What does “The following object is masked from ‘package:xxx'” mean?
  10. Vectorized IF statement in R?
  11. Excel UNIQUE Across Columns
  12. How can I remove an element from a list?
  13. Save each sheet in a workbook to separate CSV files
  14. Remove backslashes from character string
  15. Detect if range is empty
  16. Checking if a worksheet-based checkbox is checked
  17. How to get help in R?
  18. Uncheck all checkboxes across entire workbook via CommandButton
  19. VBA workbooks.Close without being prompted to if the user wants to save?
  20. Excel: Use a cell value as a parameter for a SQL query
  21. Copy a selected range to another worksheet
  22. Excel macro – paste only non empty cells from one sheet to another
  23. Convert from US to UK format
  24. How to get mean, median, and other statistics over entire matrix, array or dataframe?
  25. The MacScript function is not working well in Office for Mac 2016! Any ideas?
  26. Create hyperlink to another sheet
  27. Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
  28. Generate N random numbers whose sum is a constant K – Excel
  29. How do I read data from a spreadsheet using the OpenXML Format SDK?
  30. Delete all data rows from an Excel table (apart from the first)

Leave a Comment