R help - Aug 2011 - Using write.table i have a table with two columns i would like to save it as an excel file

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.

I'd suggest you should probably just use the simpler write.csv() function to
make a file type that will move much more conveniently between Excel and R.

The syntax is:

write.csv(ThingBeingSaved, "filename.csv")

If you only put the file name to write.csv it will be placed in your working
directory, which you can find by running getwd() at the command line. If you
put a whole path, R will put it there. If you want to change your working
directory, setwd() can do that.

As to what to name the file, well -- that's your problem, but it can be
basically anything you want as long as it ends in ".csv". (It
doesn't even
technically have to do that, but please do -- it will make your life better
when dealing with Excel)

Michael

On Thu, Aug 25, 2011 at 12:58 PM, kevin123 <kevincorry123@gmail.com>
wrote:
> 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@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.
>
	[[alternative HTML version deleted]]

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.