What happens if I want to automate this process for say 500 vectors?
--
View this message in context:
http://r.789695.n4.nabble.com/how-to-you-output-a-vector-to-a-column-in-excel-tp2530470p2536402.html
Sent from the R help mailing list archive at Nabble.com.
Well that depends which process you are automating, how your vectors
are stored, and where you want them going. Do you want 500 Excel
spreadsheets with each vector in Column A? Do you want 1 spreadsheet
with each vector appended below the previous? Do you want 1
spreadsheet with each vector in
If you have Excel running with the sheet that you want to use open, then in R
you can just do:
write.table( 1:10, 'clipboard', sep='\t', row.names=FALSE, col.names=FALSE )
(replace 1:10 with your vector)
Then go to excel, right click on the cell where you want the first number to
be, and
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
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
Try
vector - c(1,2,3,4)
write.table(data.frame(vector), example.xls, col.names = TRUE, row.names =
FALSE)
See ?write.table for more information.
HTH,
Jorge
On Tue, Sep 7, 2010 at 5:33 PM, lord12 wrote:
What is the syntax for this?
If you have: vector = c(1,2,3,4), how would you output
6 matches
Mail list logo