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.
writing a data frame in excel format
3 messages · Mario Morales, Arne Henningsen, PIKAL Petr
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/
Hi Arne
On 26 Apr 2005 at 9:29, Arne Henningsen wrote:
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 = "," )
Or you can write it as write.table(r.data.frame, "excel.file.xls", sep="\t", na="", row.names=F) which I can usually open in Excel just by clicking on it. Cheers Petr
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/
______________________________________________ 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
Petr Pikal petr.pikal at precheza.cz