Skip to content

Writing .xlsx files

2 messages · Katrien Baert, Gabor Grothendieck

#
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).
#
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: