Re: [R] Help on write.xlsx library(xlsx)

Hi, append=TRUE is supposed to work for appending new sheets to an existing spreadsheet. That is the most common use. I'll improve the documentation of write.xlsx. If you want to append to an existing sheet, you have two choices: 1) remove the sheet first, and than write it again with the

[R] Help on write.xlsx library(xlsx)

Hi Adrian, dat=data.frame(matrix(0,3,3)) write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet1",append=F) write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet2",append=F) The above code works and creates new worksheets. But if I want to append to an existing worksheet I seem to get an error. wri