Hey Pankaj,

Have you tried using the xlsReadWrite package. I am not on windows so I
can't really test it out but after installing the package something of the
form
should work.

for (column.index in 1:ncol(data)){
write.xls(data[,column.index],"xlfile.xls", sheet=column.index)
}

Good luck,
Achilleas


On Thu, Nov 18, 2010 at 11:11 AM, pankaj borah
<pankajborah2k3@yahoo.co.in>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
>

	[[alternative HTML version deleted]]

