[R] Writing a function, want a string argument to define the name of the excel sheet to be called

My question is this: is there a way I can make one of the arguments of the function be a string the user can enter, and then have that be the excel filename? ie, foo - function(x,y,NAME){ #make a matrix with x rows and y cols M - matrix(nrow=x,ncol=y) #write the matrix write.table(M, file =

Re: [R] Writing a function, want a string argument to define the name of the excel sheet to be called

Sure, change your example as follows and then you can pass the name properly: foo - function(x,y,NAME = filename.csv){ #make a matrix with x rows and y cols M - matrix(nrow=x,ncol=y) #write the matrix write.table(M, file = NAME,append=TRUE, sep = ,) } Bryan Prof. Bryan Hanson

Re: [R] Writing a function, want a string argument to define the name of the excel sheet to be called

Thank you very much, that does exactly what I want it to! :) Aodhán -- View this message in context: http://r.789695.n4.nabble.com/Writing-a-function-want-a-string-argument-to-define-the-name-of-the-excel-sheet-to-be-called-tp4128384p4128495.html Sent from the R help mailing list archive at

Re: [R] Writing a function, want a string argument to define the name of the excel sheet to be called

Just a heads up -- I don't think your code will work with an actual .xls(x) file, only .txt, .csv, etc (aka, plain text files). I may be wrong about that, but if you actually need to work with Excel files directly you will need an additional package. Michael On Thu, Dec 1, 2011 at 9:10 AM,

Re: [R] Writing a function, want a string argument to define the name of the excel sheet to be called

Thanks Michael, I'll keep that in mind if I want to do anything more complicated. -- View this message in context: http://r.789695.n4.nabble.com/Writing-a-function-want-a-string-argument-to-define-the-name-of-the-excel-sheet-to-be-called-tp4128384p4130233.html Sent from the R help mailing list