Hi,
2007/2/9, Mark W Kimpel <mwkimpel at gmail.com>:> I can currently append an entire worksheet with write.xls, but would
> also like to be able to append within the same worksheet. Is this
> possible?
Of course. Please see ?xls.open, ?xls.sheet and ?write.xls (note the
'keep' argument!). I give you a short example at the end of the email.
>It doesn't seem to work if I use append = T
I am not aware of an issue. Please post (better email) your code. BTW
the 'append' argument is only meant for single operations (the whole
sheet will be re-read and rewritten each time).
A last thing, such specific xlsReadWrite(Pro) questions are not very
on topic for the the r-devel list. I don't know for sure, but I
strongly suspect that this is not be appreciated here. It is probably
better you just email me.
Cheers,
Hans-Peter
--------
(the example is with read, but write is analogue)
rfile <- "TestReadDataFile.xls"
cat( "### TEST: xls.open and xls.close\n" )
exc <- xls.open( rfile )
res1 <- read.xls( exc,, 1, from = 3, cols = 1 )[[1]]
# switch to character sheet, check and read
xls.sheet( exc, "select", "characterSheet" )
# switch to logical sheet, check and read
xls.sheet( exc, "select", "logicalSheet" )
res1 <- read.xls( exc, type = "logical", from = 3, cols = 1 )
xls.close( exc )
cat( "### TEST: keep\n" )
# read first column from first sheet
res1 <- read.xls( rfile,, 1, from = 3, cols = 1, keep = TRUE )[[1]]
# switch to character sheet, check and read
xls.sheet( rfile, "select", "characterSheet", keep = TRUE )
# switch to logical sheet, check and read
xls.sheet( , "select", "logicalSheet", keep = TRUE )
# with the next command the file will be closed (without saving)
res1 <- read.xls( , type = "logical", from = 3, cols = 1, keep =
FALSE )