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.
