[R] writing a data frame in excel format

Arne Henningsen ahenningsen at email.uni-kiel.de
Tue Apr 26 09:29:08 CEST 2005


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/




More information about the R-help mailing list