[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