[R] Odp: problem with writing data to *.xls file

Petr PIKAL petr.pikal at precheza.cz
Wed Jan 21 11:33:59 CET 2009


Hi

It depends if you have Excel available

write.excel<-function(tab, ...) write.table( tab, "clipboard", sep="\t", 
row.names=F)

this function I use for copying object through clipboard to opened Excel 
file.

just

write.excel(someobject)
open excel list
Ctrl-V

puts an object into a list.

Regards
Petr


r-help-bounces at r-project.org napsal dne 20.01.2009 15:18:00:

> Hi all,
> 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
> and i have to insert the data in to the consicutive rows related to the
> previous data
> 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
> 
> thanks in advance
> 
>    [[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at 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.




More information about the R-help mailing list