AOLeary
2011-Dec-01 13:43 UTC
[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 = "result.csv",append=TRUE, sep = ",") } I've had a look but I couldn't find help for this particular problem and it's one I'd like to solve, so I can change make several excel files to solve the analysis my actual function does. Thank you very much, 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-tp4128384p4128384.html Sent from the R help mailing list archive at Nabble.com.
Bryan Hanson
2011-Dec-01 14:02 UTC
[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 Dept of Chemistry & Biochemistry DePauw University Greencastle IN 46135 USA academic.depauw.edu/~hanson/deadpezsociety.html github.com/bryanhanson academic.depauw.edu/~hanson/UMP/Index.html On Dec 1, 2011, at 8:43 AM, AOLeary wrote:> 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 = "result.csv",append=TRUE, sep = ",") > } > > I've had a look but I couldn't find help for this particular problem and > it's one I'd like to solve, so I can change make several excel files to > solve the analysis my actual function does. > > Thank you very much, > 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-tp4128384p4128384.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.
AOLeary
2011-Dec-01 14:10 UTC
[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 Nabble.com.