Skip to content

Instantly share code, notes, and snippets.

@hrstt
Created November 11, 2016 00:43
Show Gist options
  • Save hrstt/ff72b8677d32304ad4158430cacb8623 to your computer and use it in GitHub Desktop.
Save hrstt/ff72b8677d32304ad4158430cacb8623 to your computer and use it in GitHub Desktop.
複数のExcelシートにデータがある場合にそれらを結合する(同一の列構成である前提)
install.packages("xlsx")
library("xlsx")
n <- 10
a <- list()
for(i in 1:n) {
a[[i]] <- read.xlsx("data.xlsx", sheetIndex=i, encoding="UTF-8", header = FALSE)
}
data <- do.call(rbind, a)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment