Merging multiple .xls files in R

Question

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?

Hello, welcome to stackoverflow: does [this](https://stackoverflow.com/questions/8091303/simultaneously-merge-multiple-data-frames-in-a-list) help? — Vincent Guillemot, Feb 08 '19 at 15:24
This might help too https://stackoverflow.com/a/48105838/786542 — Tung, Feb 08 '19 at 15:30

Mukul · Answer 1 · 2019-02-08T19:57:25.307

1

I have found readxl package to be more friendly when importing .xlsx files or .xls files. Assuming each of the .xls file contains just one sheet to be imported the below code should work for you.

library(googledrive)

drive_find(n_max = 50)

library(readxl)

inputfiles <- list.files(pattern = "*PDOL_dataexport")

df.list<-lapply(inputfiles ,function(x) read_xls(x))

library(dplyr)

consolidated_data<-bind_rows(df.list)

edited Feb 08 '19 at 19:57

answered Feb 08 '19 at 17:04

Mukul

36
3

But how do I merge them? Please see my last question. – Ross Molden Feb 08 '19 at 17:33
I have edited the answer. The last two lines of code will solve the problem – Mukul Feb 08 '19 at 19:59
Hi, that helped thank you. However I am still having difficulties, I have edited the question - could you please help? – Ross Molden Feb 10 '19 at 13:25

Merging multiple .xls files in R

1 Answers1

Linked