[BioC] How to export dataframes to xls
Markus Boenn
boenn at informatik.uni-halle.de
Fri Nov 19 09:54:42 CET 2010
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 at 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)
More information about the Bioconductor
mailing list