Re: [R] export tables to excel files on multiple sheets with titles for each table

2010-07-15 Thread Erich Neuwirth
If you are exporting your dataframes to Excel on Windows and if you have Excel installed and if you are willing to make your hands dirty by programming VBA (the programming language built into Excel) and if you are willing to install RExcel (by way of the CRAN package RExcelInstaller or by

Re: [R] export tables to excel files on multiple sheets with titles for each table

2010-07-14 Thread Erich Neuwirth
tables to excel files on multiple sheets with titles for each table Hello R-users, Checking the archives, I recently came across this topic: export tables to Excel files (http://r.789695.n4.nabble.com/export-tables-to-Excel-files-td1565679.html#a1565679), , and the following interesting

Re: [R] export tables to excel files on multiple sheets with titles for each table

2010-07-14 Thread Whit Armstrong
(with a title corresponding to the name of the list element). -Whit On Tue, Jul 13, 2010 at 4:21 PM, eugen pircalabelu eugen_pircalab...@yahoo.com wrote: Hello R-users, Checking the archives, I recently came across this topic: export tables to Excel files (http://r.789695.n4.nabble.com/export

[R] export tables to excel files on multiple sheets with titles for each table

2010-07-13 Thread eugen pircalabelu
Hello R-users, Checking the archives, I recently came across this topic: export tables to Excel files (http://r.789695.n4.nabble.com/export-tables-to-Excel-files-td1565679.html#a1565679), and the following interesting references have been proposed: http://rwiki.sciviews.org/doku.php?id

Re: [R] export tables to excel files on multiple sheets with titles for each table

2010-07-13 Thread Felipe Carrillo
...@yahoo.com To: R-help r-h...@stat.math.ethz.ch Sent: Tue, July 13, 2010 1:21:33 PM Subject: [R] export tables to excel files on multiple sheets with titles for each table Hello R-users, Checking the archives, I recently came across this topic: export tables to Excel files (http://r

Re: [R] export tables to excel files on multiple sheets with titles for each table

2010-07-13 Thread Marc Schwartz
Sent: Tue, July 13, 2010 1:21:33 PM Subject: [R] export tables to excel files on multiple sheets with titles for each table Hello R-users, Checking the archives, I recently came across this topic: export tables to Excel files (http://r.789695.n4.nabble.com/export-tables-to-Excel-files

Re: [R] export tables to excel files on multiple sheets with titles for each table

2010-07-13 Thread Gabor Grothendieck
On Tue, Jul 13, 2010 at 4:21 PM, eugen pircalabelu eugen_pircalab...@yahoo.com wrote: Hello R-users, Checking the archives, I recently came across this topic: export tables to Excel files (http://r.789695.n4.nabble.com/export-tables-to-Excel-files-td1565679.html#a1565679),  and the following

Re: [R] export tables to Excel files

2010-02-25 Thread Erich Neuwirth
OK, I think dirung the disuccion we mixed up the directions of transfer. The example I sent was Excel - R For R - Excel you need something like RInterface.GetDataframe dfname, Worksheets(wsname).Range(A1) dfname, wsname and the cell refence (A1) have to be given for each dataframe you want to

[R] export tables to Excel files

2010-02-23 Thread Ivan Calandra
Dear R users, I've just posted a similar question about Illustrator. This time I would like to export the results of my statistic tables and my dataframes into Excel files. Up to now I've used write.csv(), but I have to resave every file in .xls in Excel. I would like to know if there is a

Re: [R] export tables to Excel files

2010-02-23 Thread Gabor Grothendieck
See R wiki for discussion of various packages that interface R and Excel: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows On Tue, Feb 23, 2010 at 4:35 AM, Ivan Calandra ivan.calan...@uni-hamburg.de wrote: Dear R users, I've just posted a similar question about Illustrator. This

Re: [R] export tables to Excel files

2010-02-23 Thread RICHARD M. HEIBERGER
Please consider RExcel, which allows complete integration of R and Excel. See http://rcom.univie.ac.at for details and examples including a video. RExcel works in both directions (R to Excel, Excel to R) with Excel 2010, 2007, 2003, and 2002. Rich [[alternative HTML version deleted]]

Re: [R] export tables to Excel files

2010-02-23 Thread Hrishi Mittal
Richard, is it possible to use RExcel under Linux, not to interface with Excel of course but to read and write Excel files? - Try http://prettygraph.com Pretty Graph , the easiest way to make R-powered graphs on the web. -- View this message in context:

Re: [R] export tables to Excel files

2010-02-23 Thread Tal Galili
Hi Richard, Thanks for pointing this out. BTW - How would you use Rexcel to write several data frames into several sheets in excel ? Thanks! Tal Contact Details:--- Contact me: tal.gal...@gmail.com | 972-52-7275845 Read me: