This is a test version of Biostars. For the public version, visit https://www.biostars.org.
How To Read Multiple Excel Sheets In R Programming?

Hi all.

I have an excel file which contains 400 sheets. How can I load this excel file to R using read.xls function? Please provide sample code for this.

r

Why do you do double post and not just edit your prev. question? And what error do you get when using read.excel?

Previous identical question was closed; the same action for this one?

@sanju : Keeping posting this on multiple fora until somebody answers is pretty rude. Your question was closed both here and at StackOverflow previously.

@Joris Meys Why did you close my question in stackoverflow? What is the reason?

1 answer

I do not have that much experience with loading exl into R... I normally save exl as .csv and then load it into R... However I believe you can use the following code.

library(gdata)

dat<-NULL; for (i in 1:2) { dat[[i]]<-read.xls("del1.xls",sheet=i,head=F) }

best Thomas

Thank you very much

Log in to answer this question.