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: Tal.Galili@gmail.com <mailto:Tal.Galili@gmail.com> | 
>  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 <petr.pikal@precheza.cz 
> <mailto:petr.pikal@precheza.cz>> 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
>
>     r-help-bounces@r-project.org <mailto:r-help-bounces@r-project.org>
>     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
>     >
>     > ______________________________________________
>     > R-help@r-project.org <mailto:R-help@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.
>
>     ______________________________________________
>     R-help@r-project.org <mailto:R-help@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.
>
>

	[[alternative HTML version deleted]]

