[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