Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@hrstt

hrstt/merge_each_excel_sheets.r

Created November 11, 2016 00:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hrstt/ff72b8677d32304ad4158430cacb8623 to your computer and use it in GitHub Desktop.
Save hrstt/ff72b8677d32304ad4158430cacb8623 to your computer and use it in GitHub Desktop.
Download ZIP
複数のExcelシートにデータがある場合にそれらを結合する（同一の列構成である前提）
Raw
merge_each_excel_sheets.r
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