hello,

over a month ago i asked this question and then wrote to the list that i
had to postpone the problem.

anyway, now i tried it again with the XLConnect package and was successfull!

i used these commands:

wb <- loadWorkbook("MyExcelFile.xlsx", create=TRUE)
createSheet(wb,name="MySheetname")
writeWorksheet(wb,MyMatrix,sheet="MySheetname",startRow=1,startCol=1)
saveWorkbook(wb)

thank you very much for your heltp!

marion

2011/9/23 Marion Wenty <marion.wenty@gmail.com>

> hello,
> thank you for your help!
> I was not successfull using the XLConnect-package. Anyway, I have to
> postpone this problem for now as I have to sort out some other other
> problems at the moment.
> marion
>
>
> 2011/9/16 Greg Snow <Greg.Snow@imail.org>
>
>> Look at the XLConnect package.
>>
>> --
>> Gregory (Greg) L. Snow Ph.D.
>> Statistical Data Center
>> Intermountain Healthcare
>> greg.snow@imail.org
>> 801.408.8111
>>
>>
>> > -----Original Message-----
>> > From: r-help-bounces@r-project.org [mailto:r-help-bounces@r-
>> > project.org] On Behalf Of Marion Wenty
>> > Sent: Friday, September 16, 2011 9:19 AM
>> > To: r-help@r-project.org
>> > Subject: [R] writing data from several matrices in R into one excel-
>> > file with several sheets
>> >
>> > hello,
>> >
>> > does anyone know how I can write several matrices from R into one exel-
>> > file
>> > using different sheets for the different matrices?
>> >
>> > thank you very much in advance for your help.
>> >
>> > Marion
>> >
>> >       [[alternative HTML version deleted]]
>> >
>> > ______________________________________________
>> > R-help@r-project.org mailing list
>> > 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]]

