[R] problem with looping on sqlSave()

Marc Schwartz marc_schwartz at me.com
Thu Feb 25 15:29:09 CET 2010

Just to confirm, WriteXLS() does not have such a parameter, but write.xls() in the xlsReadWRite package does. As you have noted however, none of these approaches are really designed to enable flexible appending to an existing Excel file.

As I believe Dieter noted in an earlier post, your best option may be to look at the RCOM/RExcel based solution, which gives you more flexibility in writing to Excel files. More info at http://rcom.univie.ac.at/.


Marc Schwartz

On Feb 25, 2010, at 8:02 AM, Ivan Calandra wrote:

> I've checked in the package WriteXLS and couldn't find such parameter (I hope I didn't overlook anything!).
> However write.xls() in xlsReadWrite package has such parameter.
> I've tried it and the problem is that, even though I can make the writing start at the last line, it will overwrite the whole file. Even if I try to append on a new sheet, the xls file is overwritten.
> One by one, I'm crossing off the possibilities...
> Thanks!
> Ivan
> Le 2/25/2010 11:58, Dieter Menne a écrit :
>> Ivan Calandra wrote:
>>> As I said earlier, none of the packages I have found (dataframes2xls,
>>> WriteXLS, xlsReadWrite, xlsx) to export to xls allow appending on the
>>> same sheet.
>> Please check again. WriteXLS has a parameter where to start writing.
>> D

More information about the R-help mailing list