writing a data frame in excel format
I save my data(frames) in csv format, which can be opened by any spreadsheet application: R> write.table( myData, "myFile.csv", col.names = NA, sep = "," ) Arne
On Tuesday 26 April 2005 04:28, Mario Morales wrote:
Hello
I know how read a file in excel format into a R data frame using the
RODBC library, but I don't know how write a R data frame in excel
format. I don't understand the instructions from RODBC user manual.
To read an excel file I use.
library(RODBC);
conex<-odbcConnectExcel("fis_quim.xls");
sqlTables(conex);
data<-sqlFetch(conex,"hoja1");
Suppose I modify data and I want to save it as an excel file, How do
I do that?
Thanks for your help
Mario Alfonso Morales Rivera
Profesor Auxiliar.
Departamento de Matem??ticas y Estadistica.
Universidad de C??rdoba.
______________________________________________ R-help at stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Arne Henningsen Department of Agricultural Economics University of Kiel Olshausenstr. 40 D-24098 Kiel (Germany) Tel: +49-431-880 4445 Fax: +49-431-880 1397 ahenningsen at agric-econ.uni-kiel.de http://www.uni-kiel.de/agrarpol/ahenningsen/