[R] Writing Macros for RExcel

[Patrick Connolly]

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
	  
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.