Thanks Frans, My files are CSV. If presume first I should convert them to Excel format and run the code you have suggested. Am I right?
Thanks again, Mohsen On Wed, Jan 13, 2016 at 9:44 AM, Frans Marcelissen < fransiepansiekever...@gmail.com> wrote: > Hi Mohse, > You can do that with the append parameter of the write.xlsx routine in the > xlsx package: > > xlsx::write.xlsx(file1,file='XXXXX.xlsx',sheetName = '1') > xlsx::write.xlsx(file2,file='XXXXX.xlsx',sheetName = '2',append = T) > > Success! > Frans > > 2016-01-13 15:18 GMT+01:00 Mohsen Jafarikia <jafari...@gmail.com>: > >> I have multiple CSV files that I would like to have them in a single Excel >> file. For example, I have file1.csv and file2.csv and I want to have >> file.xls where file1.csv and file2.csv each have been copied to a single >> sheet of the file.xls file. >> >> Thanks, >> Mohsen >> >> [[alternative HTML version deleted]] >> >> ______________________________________________ >> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see >> 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. >> > > [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
