How to create a dataframe in R from an Excel with several sheets?

Question

I have an Excel workbook with 10 sheets, each one with the name of a country. The first row of all sheets is the same. What I need is to join them all in a single dataframe in R. I have been using the "readxlsx" library, but I can only read one sheet at a time, and I still don't know how to join them all ...

Any help will be very appreciated.

Koundy · Accepted Answer · 2021-04-07 05:15:30Z

1

Try this. read all the files into a list using for loop and then you can combine all the data frames

data_list <- list()

for(i in 1:10){
data_list[[i]] <- readxlsx('excel_file', sheet = i)
}

combined_dataframe <- do.call(rbind, data_list)

answered Apr 7, 2021 at 5:15

Koundy

5,6353 gold badges28 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Valeria Arango Over a year ago

Thanks! It was really helpfull.

Collectives™ on Stack Overflow

How to create a dataframe in R from an Excel with several sheets?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related