[R] Odp: Using write.table i have a table with two columns i would like to save it as an excel file

Petr PIKAL petr.pikal at precheza.cz
Fri Aug 26 10:25:16 CEST 2011


Hi

I use this kind of output to excel if the table is not too big

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

In excel sheet I press ctrl - V to copy from clipboard

Regards
Petr
 
> Using write.table i would like to save data  as an excel file to a 
folder. I
> am not too sure how to write the file path or what to name the file. I 
would
> appreciate any feedback. 
> 
> 
> > write.table(x, file = "", append = FALSE, quote = TRUE, sep = " ",
> +             eol = "\n", na = "NA", dec = ".", row.names = TRUE,
> +             col.names = TRUE, qmethod = c("escape", "double"),
> +             fileEncoding = "")
> "area" "bedrooms" "sale.price"
> 
> "9" 694 4 192
> "10" 905 4 215
> "11" 802 4 215
> "12" 1366 4 274
> "13" 716 4 112.7
> "14" 963 4 185
> "15" 821 4 212
> "16" 714 4 220
> "17" 1018 4 276
> "18" 887 4 260
> "19" 790 4 221.5
> "20" 696 5 255
> "21" 771 5 260
> "22" 1006 5 293
> "23" 1191 6 375
> 
> 
> --
> View this message in context: http://r.789695.n4.nabble.com/Using-write-
> 
table-i-have-a-table-with-two-columns-i-would-like-to-save-it-as-an-excel-
> file-tp3768829p3768829.html
> Sent from the R help mailing list archive at Nabble.com.
> 
> ______________________________________________
> 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