Re: [R] Writing .xlsx files

2009-04-15 Thread 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 wrote: > Dear all, > > I have been looking f

[R] Writing .xlsx files

2009-04-15 Thread Katrien Baert
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