read.xlsx : would like to read in ALL sheets at once, or so..

143 views
Skip to first unread message

Marijan Holjevac

unread,
Feb 25, 2015, 3:53:23 PM2/25/15
to r-packa...@googlegroups.com
As I see it, it is not possible to read in all sheets of an xlsx file at once, each being another data.fram .. ? // this question includes all possible variations one could imagine regarding more "flexibility"

How hard would it be to implement such a feature, myself ?

... Ahh ok, i just looked into the source code

getSheets <- function() does the work already, is that correct ? I get a list of all the sheets, so i could do it just the following way :

i add to the source code in the read.xlsx function the option "ALL", and in this case just return <sheets>, which was initialized by

the commands             wb <- loadWorkbook(file)
                                  sheets <- getSheets(wb)

that should work, wouldn't it ?

[don't wonder, i'm a "newbie" and have never tried modify open source software..]

Thx so much for your implementation of the package !

Marijan 


Message has been deleted
Message has been deleted

Marijan Holjevac

unread,
Feb 25, 2015, 4:18:45 PM2/25/15
to r-packa...@googlegroups.com
no, i have to do more .. i shall try it ; if anyone is interested to (maybe) see a possible "solution", let me know, i would
be then glad to share a "proposal" !

Reply all
Reply to author
Forward
0 new messages