R help - Feb 2011 - Rexcel for mac

Is there anything out there which replicates the functionality of
RExcel on a mac?  I have Excel for mac, and would just like something
which makes its easy to put sheets into R as a dataframe etc.

On Feb 4, 2011, at 4:36 AM, Clayton Coffman wrote:
> Is there anything out there which replicates the functionality of
> RExcel on a mac?  I have Excel for mac, and would just like something
> which makes its easy to put sheets into R as a dataframe etc.

On OSX, I believe that the two primary options will be:

1. The read.xls() function in the gdata package from CRAN. This requires Perl,
which is installed by default on OSX.

2. Using RODBC from CRAN along with an ODBC driver from Actual Tech
(http://www.actualtech.com/product_access.php).


I believe that both will handle at least up through Office 2008 based files. I
am not sure about Office 2011 however, if you have the latest version of Office
for OSX.


Also, as an FYI, there are two relevant R SIG lists:

https://stat.ethz.ch/mailman/listinfo/r-sig-mac

and

https://stat.ethz.ch/mailman/listinfo/r-sig-db


HTH,

Marc Schwartz

On Fri, Feb 4, 2011 at 5:36 AM, Clayton Coffman
<clayton.coffman at gmail.com> wrote:
> Is there anything out there which replicates the functionality of
> RExcel on a mac? ?I have Excel for mac, and would just like something
> which makes its easy to put sheets into R as a dataframe etc.
>
See:

http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows


-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com