R help - Sep 2010 - 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.

 

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

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 new data
2) use low level functions, that is: setCellValue, etc.

Best,
Adrian


On Mon, 6 Sep 2010, Ravi S. Shankar wrote:
> 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
>
> 
> e-mail in error) please notify the sender immediately and destroy this
e-mail. Any unauthorized copying, disclosure or distribution of
> the material in this e-mail is strictly forbidden.  Any views or opinions
presented are solely those of the author and do not
> necessarily represent those of Amba Holdings Inc., and/or its affiliates. 
Important additional terms relating to this email can be obtained
> at  http://www.ambaresearch.com/disclaimer
>