title: Merging multiple .xls files in R
body: <p>I am trying to merge a list of <code>.xls</code> files in google drive. I have now managed to create a list of all the files I need, but for some reason I still can't manage to merge them, this is the code I have so far:</p>
  <pre><code>library(googledrive)
  inputfiles &lt;- drive_ls(path = &quot;Email It In&quot;, pattern = &quot;*PDOL_dataexport&quot;, n_max = 50)
  
  library(readxl)
  df.list&lt;- lapply(inputfiles,function(x) read_xls(x))
  library(dplyr)
  consolidated_data&lt;-bind_rows(df.list)
  </code></pre>
  <p>The second part of the code throws up the following error:</p>
  <pre><code>Error: `path` must be a string 
  </code></pre>
  <p>I must be entering the path (inputfiles) incorrectly for lapply, can someone please help?</p>