[R] Import and export .xls

[Stephen Liu]

Hi Gabor

Thanks for your advice and URL

Win 7 64 bit 
login as user


I found following script:-
[R] Excel Export in a beauty way
https://stat.ethz.ch/pipermail/r-help/2009-June/200607.html

Ran the script on R.  After finish executed:-
> export.xls(iris)

It seemed creating iris.xls on the fly.  But I can't find it after finish.  Can 
you help?

If the script works how to save it for future use?

TIA

B.R.
Stephen L






----- Original Message ----
From: Gabor Grothendieck <ggrothendieck at gmail.com>
To: Stephen Liu <satimis at yahoo.com>
Cc: r-help at r-project.org
Sent: Sat, November 20, 2010 11:58:49 PM
Subject: Re: [R] Import and export .xls

On Sat, Nov 20, 2010 at 10:53 AM, Stephen Liu <satimis at yahoo.com> wrote:
> Whether I need following package to export R data to Excel spreadsheet and to
> import .xls file to R?
>
> xlsReadWrite
>http://www2.warwick.ac.uk/fac/sci/moac/degrees/modules/ch923/r_introduction/excel_in_r/
>/
>

Yes, you can use that or a number of other packages to move data
between R and Excel. See:
http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows

-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com