I think you want ?assign
Bert Gunter
"The trouble with having an open mind is that people keep coming along and
sticking things into it."
-- Opus (aka Berkeley Breathed in his "Bloom County" comic strip )
On Fri, Mar 29, 2019 at 10:39 AM Assa Yeroslaviz <fry...@gmail.com> wrote:
> I am trying to automate the way i read my tables. I have an Excel sheet I'm
> reading using openxlsx package. The sheet contains over 30 sheets, i would
> like to save each of them as separate objects.
>
> my workflow for now is as such:
>
> wb <- loadWorkbook(xlsxFile = "Output/Up_Down_Regulated_Gene_Lists.xlsx")
> NAMES <- gsub(pattern = " ", replacement = "_", x = names(wb))
> [1] "KO1_vs._WT_up" "KO2_vs._WT_down" "KO3_vs._WT_up"
> "KO1_vs._WT_down" "KO2_vs._WT_up" ...
> for (i in 2:length(names(wb)) ){
> tmp <- read.xlsx(wb, sheet = i)
>
> ... Here I would like to have each sheet read in and sacved as a separate
> data.frame.
>
> }
>
> Is there a way to read for each sheet the name from names(wb) and convert
> it to a name for the object?
>
> something like this
> The object KO1_vs._WT_up will save the first sheet with the same name
> The object KO2_vs._WT_down will save the second sheet.
> etc.
>
> Any ideas?
>
> thanks
> Assa
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.
>
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.
