[R] 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. __ 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.
Re: [R] Rexcel for mac
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 __ 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.
Re: [R] Rexcel for mac
On Fri, Feb 4, 2011 at 5:36 AM, Clayton Coffman clayton.coff...@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 __ 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.
