title: Error: could not find function "read_excel" using R on Mac
body: <p>I am trying to link up my excel data set to R for statistical analysis. I am running on OSX Sierra (10.12.6) with R studio (1.0.153) and Java 8 (update 144). </p>
  
  <p>The function "read_excel" was able to open my excel document a week ago. When I moved the excel and the R document together to another folder, it no longer worked. Reloading the libraries has had no effect. After multiple attempts (and restarting R studio and computer), something finally worked but function "lmer" was no longer found. After reloading library "lme4", "read_excel" no longer worked!</p>
  
  <p>I have also tried using "read.xlsx" and "readWorksheet(loadWorkbook(...))", which didn't work. "read.csv" also did not work properly since the commas were creating disorganized columns and I am dealing with a larger excel workbook with ongoing changes.</p>
  
  <p>Reading on Stack, question <a href="https://stackoverflow.com/questions/7049272/importing-xlsx-file-into-r">Importing .xlsx file into R</a> has not resolved my issue! Please help!</p>
  
  <p>Libraries loaded:</p>
  
  <pre><code>library(multcomp)
  library(nlme)
  library(XLConnect)
  library(XLConnectJars)
  library(lme4)
  library(car)
  library(rJava)
  library(xlsx)
  library(readxl)
  </code></pre>
  
  <p>R data file:</p>
  
  <pre><code>Dataset &lt;- read_excel("Example.xlsx",sheet="testing")
  #alternative line: Dataset &lt;- read.xlsx("~/Desktop/My Stuff/Sample/Example.xlsx", sheet=7)
  
  Dataset$AAA &lt;- as.factor(Dataset$AAA)
  Dataset$BBB &lt;- as.factor(Dataset$BBB)
  Dataset$CCC &lt;- as.numeric(Dataset$CCC)
  Dataset$DDD &lt;- as.numeric(Dataset$DDD)
  
  Dataset_lme = lmer(CCC ~ AAA + BBB + (1|DDD), data=Dataset)
  </code></pre>