[R] Help needed with my code for merging multiple xls files from google drive

Ross Molden ro@@@|@mo|den @end|ng |rom gm@||@com
Mon Feb 11 14:11:29 CET 2019


Hi guys,

I am trying to merge a list of .xls 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:

library(googledrive) inputfiles <- drive_ls(path = "Email It In", pattern = "*PDOL_dataexport", n_max = 50)

library(readxl) df.list<- lapply(inputfiles,function(x) read_xls(x)) library(dplyr) consolidated_data<-bind_rows(df.list)

The second part of the code throws up the following error: 

Error: path must be a string 

I must be entering the path (inputfiles) incorrectly for lapply, can someone please help?

Thank in advance!
Ross
	[[alternative HTML version deleted]]



More information about the R-help mailing list