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.
write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet2",append=T) - This gives
an error saying "The workbook already contains a sheet of this name"
Could you please let me know how to append data to an existing sheet
and not create a new sheet each time?
Thank you
Ravi
This e-mail may contain confidential and/or privileged i...{{dropped:13}}
______________________________________________
[email protected] 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.
