[R] Multiple CSV files in different sheets of an Excel file

[Mohsen Jafarikia]

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 <
fransiepansiekevertje at 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 <jafarikia at 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 at 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]]