Hi Mohsen, Just read them with read.csv or read.table (file1<-read.csv(file=.....), and you can write them. Success! Frams
2016-01-13 15:47 GMT+01:00 Mohsen Jafarikia <jafari...@gmail.com>: > 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.
