I have columns of data in Excel 2007, A2:A196, B2:B196...ET2:ET196 that I would like to place into arrays in R. I have been trying to write a macro that would automatically create all of my arrays for me with a array names coming from the cells A1, B1, etc. I can manually create an array using RExcel<Put R Var< Array, but I don't want to manually create all 150 arrays this way. Thanks for the help. -- View this message in context: http://r.789695.n4.nabble.com/Writing-Macros-for-RExcel-tp3478981p3478981.html Sent from the R help mailing list archive at Nabble.com.
On Wed, 27-Apr-2011 at 11:00AM -0700, wwreith wrote:
|> I have columns of data in Excel 2007, A2:A196, B2:B196...ET2:ET196 that I
|> would like to place into arrays in R. I have been trying to write a macro
|> that would automatically create all of my arrays for me with a array names
|> coming from the cells A1, B1, etc.
|>
|> I can manually create an array using RExcel<Put R Var< Array, but I
don't
|> want to manually create all 150 arrays this way.
You seem to be making life too difficult for yourself. Check out the
read.table function. When you understand what it does, you'll see
your task is trivial.
|>
|> Thanks for the help.
|>
|> --
|> View this message in context:
http://r.789695.n4.nabble.com/Writing-Macros-for-RExcel-tp3478981p3478981.html
|> Sent from the R help mailing list archive at Nabble.com.
|>
|> ______________________________________________
|> 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.
--
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.
___ Patrick Connolly
{~._.~} Great minds discuss ideas
_( Y )_ Average minds discuss events
(:_~*~_:) Small minds discuss people
(_)-(_) ..... Eleanor Roosevelt
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.
RExcel has its own mailing list (the included documentation says so!) Please subscribe at rcom.univie.ac.at and post your question on that list. On 4/27/2011 8:00 PM, wwreith wrote:> I have columns of data in Excel 2007, A2:A196, B2:B196...ET2:ET196 that I > would like to place into arrays in R. I have been trying to write a macro > that would automatically create all of my arrays for me with a array names > coming from the cells A1, B1, etc. > > I can manually create an array using RExcel<Put R Var< Array, but I don't > want to manually create all 150 arrays this way. > > Thanks for the help. > > -- > View this message in context: http://r.789695.n4.nabble.com/Writing-Macros-for-RExcel-tp3478981p3478981.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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. >