Re: [R] Use "append" in the function write.xlsx2 or write.xlsx (openxlsx package)

2016-05-03 Thread Ivan Calandra
Not sure this is what you need or the best way to do it, but you could do something along these lines: #first create a file name that depends on which file names already exist. The big thing here is list.files() but you probably need to adapt the rest to your needs: fileNumber <-

[R] Use "append" in the function write.xlsx2 or write.xlsx (openxlsx package)

2016-05-02 Thread jpm miao
Hi, I am trying to print several dataset in several different sheets of the same xlsx file. I sometimes run the codes more than once, and I need to erase all things in the target file, and I do not use "append" in the first function call. However I want to write it in a loop. Is there a way to