On Mar 6, 2010, at 12:17 PM, Ivan Calandra wrote:
Dear Mac users,
Up to now, I've run R on Windows and I have some problems using my scripts on
Mac OS X 10.6, R.app GUI 1.31 (5537 Leopard build 64-bit).
Here is the code I use to export a data.frame to an *.xls file:
xlsFile -
Hi Ivan,
Do you have an Excel ODBC driver? My understanding is that Microsoft
does not provide one of OS X, so you may need to buy a driver to get it
to work. I know a company called Opensoft makes one.
Dan
On Sat, 2010-03-06 at 09:17 -0800, Ivan Calandra wrote:
Dear Mac users,
Up to now,
On Mar 6, 2010, at 11:17 AM, Ivan Calandra wrote:
Dear Mac users,
Up to now, I've run R on Windows and I have some problems using my scripts on
Mac OS X 10.6, R.app GUI 1.31 (5537 Leopard build 64-bit).
Here is the code I use to export a data.frame to an *.xls file:
xlsFile -
How am I supposed to do that?
Marc Schwarz advised me to use the package WriteXLS instead.
Thanks for your help already
regards,
Ivan
Le 6 mars 2010 à 18:37, Simon Urbanek a écrit :
On Mar 6, 2010, at 12:17 PM, Ivan Calandra wrote:
Dear Mac users,
Up to now, I've run R on Windows and
Ivan,
A quick heads up.
I had a brief offlist exchange with Prof. Ripley, during which he noted two
things:
1. His MS Office 2008 installation on OSX does not have an ODBC driver. So it
would seem that it is not available from MS, which would make sense with Actual
Tech selling one.
2. The
I might suggest looking into the possibility of using SQLite, which is
cross platform and free (in fact, it's public domain rather than GNU
etc.).
You can then set up an Excel spreadsheet to populate itself from the
SQLite db. http://www.sqlite.org. It's already available on the Mac -