Thank you for the help, csv works much better, Kevin
On Thu, Aug 25, 2011 at 11:47 AM, R. Michael Weylandt < michael.weyla...@gmail.com> [via R] < ml-node+3769105-2014137821-262...@n4.nabble.com> wrote: > 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 <[hidden > email]<http://user/SendEmail.jtp?type=node&node=3769105&i=0>> > 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. > > > > ______________________________________________ > > [hidden email] > > <http://user/SendEmail.jtp?type=node&node=3769105&i=1>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]] > > ______________________________________________ > [hidden email] <http://user/SendEmail.jtp?type=node&node=3769105&i=2>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. > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > 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-tp3768829p3769105.html > To unsubscribe from Using write.table i have a table with two columns i > would like to save it as an excel file, click > here<http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3768829&code=a2V2aW5jb3JyeTEyM0BnbWFpbC5jb218Mzc2ODgyOXwxNTc4MTA3MzY1>. > > -- 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-tp3768829p3769429.html Sent from the R help mailing list archive at Nabble.com. [[alternative HTML version deleted]] ______________________________________________ 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.
