Thanks a lot Marc for your detailed answer. With this information, I'll find what I can do with my data. Thanks again to all of you Have a nice weekend Ivan
Le 6 mars 2010 à 20:14, Marc Schwartz a écrit : > 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.calan...@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@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.calan...@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@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.calan...@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@stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-mac
