Re: [R] Exporting a dataframe from R to Excel

From: Henrique Dallazuanna <wwwhsd_at_gmail.com>
Date: Mon, 25 Feb 2008 10:17:37 -0300

You have tried write.table?

write.table(x, file="file.xls", sep="\t", row.names=F)

On 25/02/2008, Nadia Theron <NadiaT_at_investec.co.za> wrote:
> I am trying to export a dateframe created in R:
>
>
>
> > Duration_summary
>
> V1 2.5 % 97.5 % V4 2.5 % 97.5 %
>
> [1,] 1 0.46076018 1.128776 1.000000 0.5280828 0.9576338
>
> [2,] 0 0.00000000 0.000000 1.000000 0.1741793 1.2352705
>
> [3,] 1 0.46566719 1.313711 1.000000 0.7233312 1.4097987
>
> [4,] 1 0.38866371 2.453226 0.976024 0.6377314 1.3493957
>
> [5,] 1 0.08894066 1.036830 1.000000 0.5270633 1.0901834
>
>
>
> into a named are in Excel of the correct size, but I do not want to
> export the rownames as well. I've tried using RODBC sqlUpdate:
>
>
>
> sqlUpdate(channel=channel, dat=Duration_summary, index = NULL,verbose =
> FALSE, test = FALSE,nastring = NULL, fast = TRUE)
>
> Error in sqlUpdate(channel = channel, dat = Duration_summary, index =
> NULL, :
>
> cannot update 'Duration_summary' without unique column
>
> Please help...
>
>
> http://www.investec.com/EmailDisclaimer/emaildisclaimer.htm
>
> The disclaimer also provides our corporate information and names of our directors as required by law.
>
> The disclaimer is deemed to form part of this message in terms of Section 11 of the Electronic Communications and Transactions Act 25 of 2002.
> If you cannot access the disclaimer, please obtain a copy thereof from us by sending an email to: disclaimer_at_investec.co.za
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help_at_r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

-- 
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O

______________________________________________
R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Mon 25 Feb 2008 - 13:22:18 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 25 Feb 2008 - 14:30:16 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive