[R] Writing Macros for RExcel

From: wwreith <reith_william_at_bah.com>
Date: Wed, 27 Apr 2011 11:00:14 -0700 (PDT)


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.
Received on Wed 27 Apr 2011 - 18:22:22 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 27 Apr 2011 - 22:50:34 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive