thr3ads.net - R help - [R] export tables to Excel files [Feb 2010]

If this information is useful, please help other people find it:
Share via:

Ivan Calandra

2010-Feb-23 09:35 UTC

[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 function or package to export 
directly into *.xls.

I have found xlsReadWrite which would be perfect for me, if only I could 
append data to an existing file (I need to do it) and it doesn't work 
with R2.10 (of course the version I use...).
Of course, since I would like to export .xls files, I would have to be 
able to read them too, which means that the package WriteXLS wouldn't be 
enough. And in any case, appending data is not possible.
The package xlsx is not what I need since I still use Excel 2003.

Are there other packages that would correspond to my needs? There might 
also be a better, completely different, approach. I'm open to all 
suggestions of course!

Thanks in advance for your help
Ivan

Gabor Grothendieck

2010-Feb-23 10:04 UTC

head link

[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
<ivan.calandra at uni-hamburg.de> wrote:> 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 function or package to export directly
> into *.xls.
>
> I have found xlsReadWrite which would be perfect for me, if only I could
> append data to an existing file (I need to do it) and it doesn't work
with
> R2.10 (of course the version I use...).
> Of course, since I would like to export .xls files, I would have to be able
> to read them too, which means that the package WriteXLS wouldn't be
enough.
> And in any case, appending data is not possible.
> The package xlsx is not what I need since I still use Excel 2003.
>
> Are there other packages that would correspond to my needs? There might
also
> be a better, completely different, approach. I'm open to all
suggestions of
> course!
>
> Thanks in advance for your help
> Ivan
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

Petr PIKAL

2010-Feb-23 10:11 UTC

head link

[R] Odp: export tables to Excel files

Hi

I use this simple statement to produce output readable directly to excel

> write.excelfunction (tab, ...) 
write.table(tab, "clipboard", sep = "\t", row.names = F)

If you put a name of a file instead of "clipboard" then you can use
output
to file and you can use append =TRUE

See ?write.table for further options. It is not so sophisticated as other 
possibilities but I got used to it and it works.

Regards
Petr

r-help-bounces at r-project.org napsal dne 23.02.2010 10:35:11:
> 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 function or package to export 
> directly into *.xls.
> 
> I have found xlsReadWrite which would be perfect for me, if only I could 
> append data to an existing file (I need to do it) and it doesn't work 
> with R2.10 (of course the version I use...).
> Of course, since I would like to export .xls files, I would have to be 
> able to read them too, which means that the package WriteXLS wouldn't
be
> enough. And in any case, appending data is not possible.
> The package xlsx is not what I need since I still use Excel 2003.
> 
> Are there other packages that would correspond to my needs? There might 
> also be a better, completely different, approach. I'm open to all 
> suggestions of course!
> 
> Thanks in advance for your help
> Ivan
> 
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide 
http://www.R-project.org/posting-guide.html> and provide commented, minimal, self-contained, reproducible code.

RICHARD M. HEIBERGER

2010-Feb-23 15:04 UTC

head link

[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]]

Hrishi Mittal

2010-Feb-23 15:21 UTC

head link

[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-to-Excel-files-tp1565679p1566021.html
Sent from the R help mailing list archive at Nabble.com.

Erich Neuwirth

2010-Feb-25 11:25 UTC

head link

[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 want to transfer.


You need to install RExcel to do this.

CRAN has a package RExcelInstaller
which does everything for you.



On 2/24/2010 4:35 PM, Tal Galili wrote:> Hi Erich.
> I admit I haven't gotten all that is necessary to implement it.
> But thanks anyway :)
> 
> Tal
> 
> 
> ----------------Contact
> Details:-------------------------------------------------------
> Contact me: Tal.Galili at gmail.com <mailto:Tal.Galili at gmail.com>
|
>  972-52-7275845
> Read me: www.talgalili.com <http://www.talgalili.com> (Hebrew) |
> www.biostatistics.co.il <http://www.biostatistics.co.il> (Hebrew) |
> www.r-statistics.com <http://www.r-statistics.com> (English)
>
----------------------------------------------------------------------------------------------
> 
> 
> 
> 
> On Wed, Feb 24, 2010 at 12:55 PM, Erich Neuwirth
> <erich.neuwirth at univie.ac.at <mailto:erich.neuwirth at
univie.ac.at>> wrote:
> 
>     This was a VBA program which from R put the dataframes into R.
>     Then in R you can do whatever you want.
> 
> 
>     On 2/24/2010 7:52 AM, Tal Galili wrote:
>     > (off mailing list)
>     > Thanks Erich for the example, only please note that I asked about
the
>     > other way around (reading the excel into R)
>     >
>     > Either way - Thanks!
>     > Tal
>     >
>     >
>     >
>     > ----------------Contact
>     > Details:-------------------------------------------------------
>     > Contact me: Tal.Galili at gmail.com <mailto:Tal.Galili at
gmail.com>
>     <mailto:Tal.Galili at gmail.com <mailto:Tal.Galili at
gmail.com>> |
>     >  972-52-7275845
>     > Read me: www.talgalili.com <http://www.talgalili.com>
>     <http://www.talgalili.com> (Hebrew) |
>     > www.biostatistics.co.il <http://www.biostatistics.co.il>
>     <http://www.biostatistics.co.il> (Hebrew) |
>     > www.r-statistics.com <http://www.r-statistics.com>
>     <http://www.r-statistics.com> (English)
>     >
>    
----------------------------------------------------------------------------------------------
>     >
>     >
>     >
>     >
>     > On Wed, Feb 24, 2010 at 1:01 AM, Erich Neuwirth
>     > <erich.neuwirth at univie.ac.at <mailto:erich.neuwirth at
univie.ac.at>
>     <mailto:erich.neuwirth at univie.ac.at
>     <mailto:erich.neuwirth at univie.ac.at>>> wrote:
>     >
>     >     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(MySheetNames)
>     >      RInterface.PutDataframe MyDFNames(i), _
>     >                  
>      Worksheets(MySheetNames(i)).Range("A1").CurrentRegion
>     >      Next i
>     >     End Sub
>     >
>     >
>     >     This will take the data in the rectangular nonempty range
>     >     anchored at cell A1 for the 3 names sheets and transfer them
>     >     to R as dataframes with the names given in MyDFNames
>     >
>     >
>     >     On 2/23/2010 10:46 PM, Tal Galili wrote:
>     >     > 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.Galili at gmail.com
>     <mailto:Tal.Galili at gmail.com> <mailto:Tal.Galili at
gmail.com
>     <mailto:Tal.Galili at gmail.com>> |
>     >      972-52-7275845
>     >     > Read me: www.talgalili.com
<http://www.talgalili.com>
>     <http://www.talgalili.com> (Hebrew) |
>     >     www.biostatistics.co.il <http://www.biostatistics.co.il>
>     <http://www.biostatistics.co.il> (Hebrew) |
>     >     > www.r-statistics.com <http://www.r-statistics.com>
>     <http://www.r-statistics.com> (English)
>     >     >
>     >    
>    
----------------------------------------------------------------------------------------------
>     >     >
>     >     >
>     >     >
>     >     >
>     >     > On Tue, Feb 23, 2010 at 5:04 PM, RICHARD M. HEIBERGER
>     >     <rmh at temple.edu <mailto:rmh at temple.edu>
<mailto:rmh at temple.edu
>     <mailto:rmh at temple.edu>>>wrote:
>     >     >
>     >     >> 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]]
>     >     >>
>     >     >> ______________________________________________
>     >     >> R-help at r-project.org <mailto:R-help at
r-project.org>
>     <mailto:R-help at r-project.org <mailto:R-help at
r-project.org>> mailing list
>     >     >> https://stat.ethz.ch/mailman/listinfo/r-help
>     >     >> PLEASE do read the posting guide
>     >     >> http://www.R-project.org/posting-guide.html
>     >     >> and provide commented, minimal, self-contained,
>     reproducible code.
>     >     >>
>     >     >
>     >     >       [[alternative HTML version deleted]]
>     >     >
>     >     > ______________________________________________
>     >     > R-help at r-project.org <mailto:R-help at
r-project.org>
>     <mailto:R-help at r-project.org <mailto:R-help at
r-project.org>> mailing list
>     >     > https://stat.ethz.ch/mailman/listinfo/r-help
>     >     > PLEASE do read the posting guide
>     >     http://www.R-project.org/posting-guide.html
>     >     > and provide commented, minimal, self-contained,
reproducible
>     code.
>     >     >
>     >     >
>     >
>     >     --
>     >     Erich Neuwirth, University of Vienna
>     >     Faculty of Computer Science
>     >     Computer Supported Didactics Working Group
>     >     Visit our SunSITE at http://sunsite.univie.ac.at
>     >     Phone: +43-1-4277-39464 Fax: +43-1-4277-39459
>     >
>     >     ______________________________________________
>     >     R-help at r-project.org <mailto:R-help at r-project.org>
>     <mailto:R-help at r-project.org <mailto:R-help at
r-project.org>> mailing list
>     >     https://stat.ethz.ch/mailman/listinfo/r-help
>     >     PLEASE do read the posting guide
>     >     http://www.R-project.org/posting-guide.html
>     >     and provide commented, minimal, self-contained, reproducible
code.
>     >
>     >
> 
>     --
>     Erich Neuwirth, University of Vienna
>     Faculty of Computer Science
>     Computer Supported Didactics Working Group
>     Visit our SunSITE at http://sunsite.univie.ac.at
>     Phone: +43-1-4277-39464 Fax: +43-1-4277-39459
> 
> 
-- 
Erich Neuwirth, University of Vienna
Faculty of Computer Science
Computer Supported Didactics Working Group
Visit our SunSITE at http://sunsite.univie.ac.at
Phone: +43-1-4277-39464 Fax: +43-1-4277-39459

Seemingly Similar Threads

Search for more seemingly similar threads

R help - Feb 2010 - export tables to Excel files

[R] export tables to Excel files

[R] export tables to Excel files

[R] Odp: export tables to Excel files

[R] export tables to Excel files

[R] export tables to Excel files

[R] export tables to Excel files

Seemingly Similar Threads