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

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 visiti

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

It isn't beautiful, but I use this package to write excel files from linux. http://github.com/armstrtw/Rexcelpoi the basic idea is that each element of a list is written as a separate sheet, but if a list element is itself a list, then all the elements of that list are written to the same sheet (

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

- Original Message ---- >>> From: eugen pircalabelu >>> To: R-help >>> Sent: Tue, July 13, 2010 1:21:33 PM >>> Subject: [R] export tables to excel files on multiple sheets with titles >>> for >>> each table >>> >>&g

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

On Tue, Jul 13, 2010 at 4:21 PM, eugen pircalabelu 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 interesting reference

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

lu >> To: R-help >> 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: >> "expo

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

To: R-help > 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

[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-td1565679.html#a1565679), and the following interesting references have been proposed: http://rwiki.sciviews.org/doku.php?id=tips:da

Re: [R] export tables to Excel files

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

Re: [R] export tables to Excel files

In RExcel, you can write VBA macros to perform R-related function. A cooked up example (not checked) Sub TransferFrames() MySheetNames = Array("Sheet1", "Sheet2", "Sheet3") MyDFNames = Array("mydf1", "mydf2", "mydf3") RInterface.StartRServer For i = Lbound(MySheetNames) to UBound(MySheetNa

Re: [R] export tables to Excel files

Thanks Gabor. I wasn't aware of that. I will upgrade to the latest version of gdata. - Try http://prettygraph.com Pretty Graph , the easiest way to make R-powered graphs on the web. -- View this message in context: http://n4.nabble.com/export-tables-to-Excel-files-tp1565679p159.html Se

Re: [R] export tables to Excel files

Note that gdata 2.7.1 can read both xls and xlsx files and is available on all platforms. If you have any problems with the CRAN version there is a pointer to the development version here and also alternative packages such as xlsx are listed: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_w

Re: [R] export tables to Excel files

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:

Re: [R] export tables to Excel files

Thanks Richard. I use gdata to work with xls files, but am looking for something under Linux which can read xlsx files. I'll try ROoo. - Try http://prettygraph.com Pretty Graph , the easiest way to make R-powered graphs on the web. -- View this message in context: http://n4.nabble.com/expo

Re: [R] export tables to Excel files

Hrishi, You can use the beta version of ROoo for Open Office, also available on the Download tab of rcom.univie.ac.at, to interface with the Open Office spreadsheet. RExcel itself uses Microsoft COM for behind-the-scenes communication and is therefore limited to Microsoft Windows. The gdata pack

Re: [R] export tables to Excel files

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: http://n4.nabble.com/export-tables-

Re: [R] export tables to Excel files

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

This post: http://www.r-bloggers.com/export-data-frames-to-multi-worksheet-excel-file-2/ Has a great overview... Contact Details:--- Contact me: tal.ga

Re: [R] export tables to Excel files

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 wrote: > Dear R users, > > I've just posted a similar question about Illustrator. > This time I would like to exp

[R] export tables to Excel files

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 fu