Re: [R] writing a data frame in excel format

From: Arne Henningsen <ahenningsen_at_email.uni-kiel.de>
Date: Tue 26 Apr 2005 - 17:29:08 EST

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@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@agric-econ.uni-kiel.de
http://www.uni-kiel.de/agrarpol/ahenningsen/

______________________________________________
R-help@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
Received on Tue Apr 26 17:35:13 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:31:26 EST