RODBC
Ivan, If you wanted to evaluate the ODBC route, the Actual Tech driver is available here: http://www.actualtech.com/product_access.php It is $29.95 U.S. In hindsight, as I don't use MS Office, I don't know if their OSX offering in fact has an ODBC driver included. Someone else here may know that. FWIW, I use Actual's Oracle ODBC driver and have been pleased with it. I should note that WriteXLS does not facilitate appending new worksheets to an existing file or new data to an existing worksheet. It creates a new .XLS file when used, overwriting an existing file of the same if it already exists. The intent is to provide the means to easily dump one or more data frames to an Excel file as a means to make data from R portable to others where an .XLS file makes sense as the vehicle, as an alternative to CSV files, etc. So the intent would be to have all of your data frames created and then use WriteXLS() to export them at once. I had this need when I was using Linux (to send data to clients on Windows) and so needed to find the way to accomplish this when Excel itself would not be available. Thus Perl was used, which makes this common approach available on Linux, OSX and Windows. Regards, Marc
On Mar 6, 2010, at 12:34 PM, Ivan Calandra wrote:
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 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 <- odbcConnectExcel("test.xls", readOnly=F)
sqlSave(xlsFile, test, tablename=test, rownames=F, addPK=T, append=F)
odbcCloseAll()
However, the function odbcConnectExcel() doesn't work on Mac.
Have you installed the necessary ODBC drivers and registered them? Cheers, Simon
Could you help me transposing this code? I don't think some sample data would be necessary, but let me know if you would like to. Thanks in advance Regards, Ivan -- Ivan CALANDRA PhD Student University of Hamburg Biozentrum Grindel und Zoologisches Museum Abt. S?ugetiere Martin-Luther-King-Platz 3 D-20146 Hamburg, GERMANY +49(0)40 42838 6231 ivan.calandra at uni-hamburg.de ********** http://www.for771.uni-bonn.de http://webapp5.rrz.uni-hamburg.de/mammals/eng/mitarbeiter.php [[alternative HTML version deleted]]
_______________________________________________ R-SIG-Mac mailing list R-SIG-Mac at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-mac
-- Ivan CALANDRA PhD Student University of Hamburg Biozentrum Grindel und Zoologisches Institut und Museum Martin-Luther-King-Platz 3 D-20146 Hamburg, GERMANY +49(0)40 42838 6231 ivan.calandra at uni-hamburg.de ********** http://www.for771.uni-bonn.de http://webapp5.rrz.uni-hamburg.de/mammals/eng/mitarbeiter.php
_______________________________________________ R-SIG-Mac mailing list R-SIG-Mac at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-mac