Merge multiple google xls files

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

Merge multiple google xls files


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?
        [[alternative HTML version deleted]]

[hidden email] mailing list -- To UNSUBSCRIBE and more, see
PLEASE do read the posting guide
and provide commented, minimal, self-contained, reproducible code.