In package 'xlsx' there is write.xlsx which will do what the OP wishes.



On Fri, Nov 19, 2010 at 12:54 AM, Markus Boenn <
boenn@informatik.uni-halle.de> wrote:

> Hello Pankaj,
>
> as far as I know there is a write.xls function in R included in package
> "marray". However, i think this function only creates a .csv-file with an
> .xls-suffix.
>
> Further (better) possible options might be the routines provided by the
> packages "WriteXLS" or "gdata".
>
> Hope this helps.
>
> Markus
>
>
> pankaj borah wrote:
>
>>
>>
>>
>> I have a     dataframe containing 104 columns and 30,000 rows.  I want to
>> extract 104 columns to a single excel file as separate spreadsheet .
>> Again each of the 104  columns are named  as say A1, A2, A3 ; B1,B2,B3;
>> C1,C2,C3 in the dataframeetc. So, instead of exporting to 104 spreadsheets I
>> want to export all the A , B, and C columns to a single spreadsheet.
>>
>>
>> How do I do that? I am a learner in R" and not an expert.
>>
>>
>> Thanks,
>>
>> Pankaj Barah
>>
>> Department of Biology, Norwegian University of Science & Technology (NTNU)
>>  Realfagbygget, N-7491 Trondheim, Norway
>>
>>
>>        [[alternative HTML version deleted]]
>>
>>  ------------------------------------------------------------------------
>>
>>
>> _______________________________________________
>> Bioconductor mailing list
>> Bioconductor@stat.math.ethz.ch
>> https://stat.ethz.ch/mailman/listinfo/bioconductor
>> Search the archives:
>> http://news.gmane.org/gmane.science.biology.informatics.conductor
>>
>
>
> --
> Diplom-Bioinform. Markus Bönn
> Martin-Luther-Universität Halle-Wittenberg
> Naturwissenschaftliche Fakultät III
> Institut für Informatik
> von-Seckendorff-Platz 1
> 06120 Halle (Saale)
>
>
> _______________________________________________
> Bioconductor mailing list
> Bioconductor@stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/bioconductor
> Search the archives:
> http://news.gmane.org/gmane.science.biology.informatics.conductor
>



-- 
If people do not believe that mathematics is simple, it is only because they
do not realize how complicated life is.
John von Neumann<http://www-groups.dcs.st-and.ac.uk/~history/Biographies/Von_Neumann.html>

	[[alternative HTML version deleted]]

