Thank you very much
• 0 views
•
link
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.
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.
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?