Dear Arun and Greg,extremly sorry for asking you into something which was quite
easy...the following command worked
>library(XLConnect)>sheets <- list()>for(x in 1:59) {>sheets[[x]] <-
>readWorksheetFromFile("PAK.xls", sheet=x[i],region="A12:M14444")>}
regardselisa
Date: Fri, 28 Dec 2012 10:56:43 -0700
Subject: Re: [R] multiple sheet in r
From: 538...@gmail.com
To: eliza_bo...@hotmail.com
CC: r-help@r-project.org
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_bo...@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.
538...@gmail.com
[[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.
