[R] Reading a data frame from R to excel

[Nandi]

There is a package called 'xlsReadWrite', which has functions like
read.xls & write.xls that might be helpful for you. You can also use
write.table to produce .csv files, but you'll have to use it in the
following manner:

write.table(DataFrame, 'ExcelFile.csv', sep=",", col.names=T,
row.names=F)

Hope this helps.
-Nandi


On Sep 15, 4:58 am, filip rendel <fili... at hotmail.com> wrote:
> Hello! I've generated multiple data frames that I wish to export to excel using the function write.table. When I do so all the data is merged into a single column in excel. I Would like the columns of my data frame in separate columns in excel as well but it doesn't work. I tried to download the package WriteXLS and installed Perl on my computer just like it was recommended. I also tried downloading dataframes2xls but none of them work. Is there an easier way of solving this?
>
> Would be very thankful for a reply!
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-h... at r-project.org mailing listhttps://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guidehttp://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.