There are many ways to open an excel file. The problem is that based on the operating system that you are working on you might face some problems using a particular method. For example, XLconnect depends on Java to run. So if your laptop/PC does not have Java installed XLconnect will not work. In this post I will try to present most of theavailable packages.
|SystemRequirements:||Java (>= 6)|
Opens both .xls and .xlsx files. Most people prefer this package because it allows you to also create excel files or amend them.
path <- "c:myfolder/myexcel.xls" wb = loadWorkbook(path)
Opens both .xls and .xlsx files.
data <- read.xlsx("myexcel.xlsx", sheet = 1, detectDates = TRUE)
|SystemRequirements:||perl (>= 5.10.0)|
data <- read.xls("myexcel.xls",sheet = 1)
*IF you are already using tidyverse most probably it is already inside that package
data <- readxl_example("myexcel.xlsx")
file <- system.file("myexcel", "myexcel.xlsx", package = "xlsx") data <- read.xlsx(file, 1)