I am trying to export a dateframe created in R:> Duration_summaryV1 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@investec.co.za [[alternative HTML version deleted]]
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
Where did you get the idea to use sqlUpdate from?
sqlSave is how you write a database to a table.
I think it would be easier to use write.csv to write a .csv file and
import that into Excel. ODBC connections to Excel work much better for
reading than for writing. And there are other ways: see the relevant
manual ('R Data Import/Export').
On Mon, 25 Feb 2008, Nadia Theron 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
Looks like a matrix to me: data frames must have row names.
>
>
> 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.
>
--
Brian D. Ripley, ripley at stats.ox.ac.uk
Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
University of Oxford, Tel: +44 1865 272861 (self)
1 South Parks Road, +44 1865 272866 (PA)
Oxford OX1 3TG, UK Fax: +44 1865 272595