Thank you all for your helpful answers
I will probably use the solution below, it seems more flexible.
Ivan
Le 2/23/2010 11:16, Tal Galili a écrit :
> p.s:
>
> From the post I linked to earlier, I personally am using this code:
>
> # install.packages("RODBC")
>
> library(RODBC)
> save2excel <- function(x, t.name <http://t.name>) sqlSave(xlsFile,
> x, tablename = t.name <http://t.name>, rownames = FALSE, addPK = T)
> xlsFile <- odbcConnectExcel("C:\\output-tables.xls", readOnly = FALSE)
>
> temp.df <- data.frame(a = rnorm(10), b = runif(10))
> temp.df2 <- data.frame(a = rnorm(10), b = runif(10))
> save2excel(temp.df, "test")
> save2excel(temp.df2, "test2")
> odbcCloseAll()
>
>
>
>
>
> ----------------Contact
> Details:-------------------------------------------------------
> Contact me: [email protected] <mailto:[email protected]> |
> 972-52-7275845
> Read me: www.talgalili.com <http://www.talgalili.com> (Hebrew) |
> www.biostatistics.co.il <http://www.biostatistics.co.il> (Hebrew) |
> www.r-statistics.com <http://www.r-statistics.com> (English)
> ----------------------------------------------------------------------------------------------
>
>
>
>
> On Tue, Feb 23, 2010 at 12:11 PM, Petr PIKAL <[email protected]
> <mailto:[email protected]>> wrote:
>
> Hi
>
> I use this simple statement to produce output readable directly to
> excel
>
>
> > write.excel
> function (tab, ...)
> write.table(tab, "clipboard", sep = "\t", row.names = F)
>
> If you put a name of a file instead of "clipboard" then you can
> use output
> to file and you can use append =TRUE
>
> See ?write.table for further options. It is not so sophisticated
> as other
> possibilities but I got used to it and it works.
>
> Regards
> Petr
>
> [email protected] <mailto:[email protected]>
> napsal dne 23.02.2010 10:35:11:
>
> > Dear R users,
> >
> > I've just posted a similar question about Illustrator.
> > This time I would like to export the results of my statistic
> tables and
> > my dataframes into Excel files.
> >
> > Up to now I've used write.csv(), but I have to resave every file
> in .xls
>
> > in Excel.
> > I would like to know if there is a function or package to export
> > directly into *.xls.
> >
> > I have found xlsReadWrite which would be perfect for me, if only
> I could
>
> > append data to an existing file (I need to do it) and it doesn't
> work
> > with R2.10 (of course the version I use...).
> > Of course, since I would like to export .xls files, I would have
> to be
> > able to read them too, which means that the package WriteXLS
> wouldn't be
>
> > enough. And in any case, appending data is not possible.
> > The package xlsx is not what I need since I still use Excel 2003.
> >
> > Are there other packages that would correspond to my needs?
> There might
> > also be a better, completely different, approach. I'm open to all
> > suggestions of course!
> >
> > Thanks in advance for your help
> > Ivan
> >
> > ______________________________________________
> > [email protected] <mailto:[email protected]> 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.
>
> ______________________________________________
> [email protected] <mailto:[email protected]> 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.
>
>
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
