Re: [R] Appending Excel File Data in different folders into Single Dataframe

Hi, Suppose I have all the folders in my working directory.  dir(recursive=T) #created two folders each with a single excel file #[1] "Folder1/File1.xls" "Folder2/File2.xls" library(XLConnect) lst1 <- lapply(dir(recursive=T),function(x) {wb <- loadWorkbook(x); readWorksheet(wb,sheet="Sheet1")}

[R] Appending Excel File Data in different folders into Single Dataframe

Hi all I have about 10 folders in my directory i.e Folder 1 – Folder 10. Each Folder has a single excel file containing data with the following attributes “State”,”lat”,”lon”, “address” i.e State Lat LonAddress Anchorage45.87576 -