[R] Writing .xlsx files

[Gabor Grothendieck]

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.Baert at 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 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.
>