R help - Apr 2009 - Writing .xlsx files

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/

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