Check out:
http://tolstoy.newcastle.edu.au/R/help/05/07/8950.html
but use
wkbk$SaveAs("\\test.xlsx")
instead of the corresponding line there.
You must have Excel 2007 on your machine for this to work.
On Wed, Apr 15, 2009 at 8:43 AM, Katrien Baert <katrien.ba...@ugent.be> wrote:
> Dear all,
>
> I have been looking for possibilities to read and write Excel 2007-files in
> and from R.
> The 'reading' part is ok through odbcConnectExcel2007 and sqlFetch(RODBC).
>
> For 'writing' I thought of using sqlSave in the same package, but it does
> not work (I think because this function starts from an existing file). Is
> there a workaround for this, or are there other plausible options for
> writing .xlsx files?
>
> With kind regards,
>
> Katrien
>
> PS: I found some information about RExcelInstaller, if this is something
> that would solve my problems could someone describe how it works (the user
> manual did not help me very much).
>
> --
> Katrien Baert
> Statistical Consultant
> IOF valorisatieconsortium Stat-Gent
>
> T 32 9 264 47 66
>
> http://www.statgent.org/
>
> ______________________________________________
> R-help@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.
>
______________________________________________
R-help@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.
