> I read data from *.xls file and i did some caliculations on that data and > now i have to create a column in the same .xls file
> i tried it with *write.xls() *but the thing is it deleted all the columns > previously presented in that file and it created a column and inserted data > can any one suggest what to do for this You cannot insert a column in the sheet but you can write a data matrix/frame which contains the newly calculated column. myfile <- "test.xls" # read data #dat <- read.xls( myfile ) dat <- cbind( 1:4, rep(41,4), rep(43,4) ) # calculate and prepare full data to write calc <- dat[,2] + 1 dat <- cbind( dat[,1], dat[,2], calc, dat[,3] ) # write (sheet will be overwritten with new data) #write.xls( dat, myfile ) -- Regards, Hans-Peter ______________________________________________ R-help@r-project.org 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.
