Re: [R] Odp: export tables to Excel files

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 <- fun

Re: [R] Odp: export tables to Excel files

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) sqlSave(xlsFile, x, tablename = t.name, rownames = FALSE, addPK = T) xlsFile <- odbcConnectExcel("C:\\output-tables.xls", readOnly = FALSE) temp

[R] Odp: export tables to Excel files

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.ta