Dear useRs, i want to open an excel file having 59 sheets in r and GOD knows the number of command i tried. unfortunately none worked, obviously error will be on my part. All the sheets contain 1 kind of data and the data starts from A12:M12 (which contains the header of the data), the line immediately under the header is blank. The number of columns of data in each sheet are same while the number of row are different as length of data is different. you help is required.. regardseliza [[alternative HTML version deleted]]
HI, Check this link: http://stackoverflow.com/questions/6894922/how-to-read-multiple-excel-sheets-in-r-programming http://theweiluo.wordpress.com/2011/09/07/how-to-read-a-multiple-sheet-excel-file-into-r/ A.K. ----- Original Message ----- From: eliza botto <eliza_botto at hotmail.com> To: "r-help at r-project.org" <r-help at r-project.org> Cc: Sent: Friday, December 28, 2012 12:37 PM Subject: [R] multiple sheet in r Dear useRs, i want to open an excel file having 59 sheets in r and GOD knows the number of command i tried. unfortunately none worked, obviously error will be on my part. All the sheets contain 1 kind of data and the data starts from? A12:M12 (which contains the header of the data), the line immediately under the header is blank. The number of columns of data in each sheet are same while the number of row are different as length of data is different. you help is required.. regardseliza ??? ??? ??? ? ??? ??? ? ??? [[alternative HTML version deleted]] ______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
If you want help from us mere mortals then it would help us to help you if you could tell us not only the number of commands that you tried but what the actual commands were. Also the phrase "none worked" does not help us help you, see fortune(324). A description of what happened and how the results (if any) differed from what you expected would help. I would suggest trying the XLConnect package, but that may be what you tried already. On Fri, Dec 28, 2012 at 10:37 AM, eliza botto <eliza_botto@hotmail.com>wrote:> > Dear useRs, > i want to open an excel file having 59 sheets in r and GOD knows the > number of command i tried. unfortunately none worked, obviously error will > be on my part. All the sheets contain 1 kind of data and the data starts > from A12:M12 (which contains the header of the data), the line immediately > under the header is blank. The number of columns of data in each sheet are > same while the number of row are different as length of data is different. > you help is required.. > regardseliza > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >-- Gregory (Greg) L. Snow Ph.D. 538280@gmail.com [[alternative HTML version deleted]]