R help - Feb 2013 - Putting an array from excel into R Studio

Dear All,

I have been using RExcel for some time and find two features especially useful:
i) The ability to select part of a worksheet and put it into R
ii) The way of viewing the code, the output and the alerts in separate panes.

The rest of R Excel I don't really use.
The major benefit for me is i) as I can use the excel as a sort of
fast access database which is convenient to edit. I can find an array
in a large number of worksheets in seconds by name, because of the
retention of the name of 'put arrays' within the spreadsheet, which is
productive.
The R blogs seem to be slightly dismissive of or do not recognise this
use for excel.

I would like to explore the use of R studio as it seems to be the tool
of choice for many, but I am reluctant to have to create csv's for a
huge number of arrays.

Is there a convenient way to get this 'put' functionality between
excel and R studio? Or, does one have to import the worksheet and then
begin the analysis through R using the RODBC package?

Many thanks,
Nick Duncan

This doesn't answer your question, but you may find some of my functions
useful:
https://github.com/geneorama/geneorama/blob/master/R/clipper.R
https://github.com/geneorama/geneorama/blob/master/R/clipped.R


You can quickly get stuff from Excel using the clipboard using clipped().
 I also added some things to remove dots from the names and that kind of
thing.  I've found it to be convenient.

The RODBC package is the most robust way that I've found to get / put data
in / out of Excel.


On Mon, Feb 11, 2013 at 11:25 AM, Nick Duncan <nickdunc@gmail.com> wrote:
> Dear All,
>
> I have been using RExcel for some time and find two features especially
> useful:
> i) The ability to select part of a worksheet and put it into R
> ii) The way of viewing the code, the output and the alerts in separate
> panes.
>
> The rest of R Excel I don't really use.
> The major benefit for me is i) as I can use the excel as a sort of
> fast access database which is convenient to edit. I can find an array
> in a large number of worksheets in seconds by name, because of the
> retention of the name of 'put arrays' within the spreadsheet, which
is
> productive.
> The R blogs seem to be slightly dismissive of or do not recognise this
> use for excel.
>
> I would like to explore the use of R studio as it seems to be the tool
> of choice for many, but I am reluctant to have to create csv's for a
> huge number of arrays.
>
> Is there a convenient way to get this 'put' functionality between
> excel and R studio? Or, does one have to import the worksheet and then
> begin the analysis through R using the RODBC package?
>
> Many thanks,
> Nick Duncan
>
> ______________________________________________
> 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.
>
	[[alternative HTML version deleted]]