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}}

