Hi, What *exactly* do you mean when you say "output"? You can write the vector to a .csv file which can easily be read by Excel using write.csv() or more generally write.table() with the appropriate arguments. There is no way (that I know of) in base R to write .xls or .xlsx files, but you can use the WriteXLS or RExcelInstaller packages to write the .xls files.
If you are meaning export a vector to an existing, open Excel spreadsheet, I suspect the process will be more difficult (although I believe there are some packages/programs that try to integrate R with Excel). However, in general I would say the easiest way to exchange data between R and Excel (and numerous other programs) is via write.table() or write.csv(). Excel, SAS, SPSS, and others can read text files that are tab, comma, etc. delimited so this is a more universal way of exchanging data. By default in Excel, the first column of a file will be column A, so if you wanted your vector in column A, just save it as a .csv, and open it in Excel and it will be there. If you wanted the vector in column C (in Excel), you would need to add some blank columns as filler (when using write.csv() ). HTH, Josh On Tue, Sep 7, 2010 at 2:33 PM, lord12 <gaut...@yahoo.com> wrote: > > What is the syntax for this? > > If you have: vector = c(1,2,3,4), how would you output this to column A of > an excel spreadsheet? > -- > View this message in context: > http://r.789695.n4.nabble.com/how-to-you-output-a-vector-to-a-column-in-excel-tp2530470p2530470.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. > -- Joshua Wiley Ph.D. Student, Health Psychology University of California, Los Angeles http://www.joshuawiley.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.
