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/. HTH, 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 ______________________________________________ R-help@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.
