When submitting your example under R.2.3.0 & WinXP, the resulting xls file was output row-wise as requested. See results below. Not sure why yours outputs columnar-wise.
To drop the variable name set col.names=FALSE. Note that the write.csv wrapper is designed to be inflexible and that you will need to use write.table instead. Here's a qoute from ?write.csv "These wrappers are deliberately inflexible: they are designed to ensure that the correct conventions are used to write a valid file. Attempts to change 'col.names', 'sep', 'dec' or 'qmethod' are ignored, with a warning." HTH, -jason Results from Sachin code. ****** Begin XLS File ******* x 1 2 3 x 1 2 3 x 1 2 3 ****** End XLS File ******* ----- Original Message ----- From: "Sachin J" <[EMAIL PROTECTED]> To: <R-help@stat.math.ethz.ch> Sent: Thursday, May 18, 2006 7:36 AM Subject: [R] write.csv + appending output (FILE I/O) > Hi, > > How can I write the output to an excel (csv) file without printing row > names (i.e without breaks). Here is my code: > > library( > > fn <- function() > { > q <- c(1,2,3) > write.csv(q,"C:/Temp/op.xls", append = TRUE, row.names = FALSE,quote = > FALSE) > } > > # Function Call > for(i in 1:3) > { > fn() > } > > Present Output : > x 1 2 3 x 1 2 3 x 1 2 3 > > Desired output: > 1 > 2 > 3 > 1 > 2 > 3 > 1 > 2 > 3 > > Also it displays following warning messages. > > Warning messages: > 1: appending column names to file in: write.table(q, "C:/Temp/op.xls", > 2: appending column names to file in: write.table(q, "C:/Temp/op.xls", > 3: appending column names to file in: write.table(q, "C:/Temp/op.xls", > > I am using R2.2.1 windows version. I tried using write.xls from "marray" > package but no success. > > Thanx in advance. > > Sachin > > __________________________________________________ > > > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! > http://www.R-project.org/posting-guide.html > ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html