Hi Frans, There is a problem that my csv files are not just several columns of data. I have some data and then a couple of tables after my data. I can't use read.table to read my files. There should be something different to look at the whole csv sheet.
Thanks again, Mohsen On Wed, Jan 13, 2016 at 9:53 AM, Frans Marcelissen < fransiepansiekever...@gmail.com> wrote: > 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.
