[R] Importing an Excel file

From: Vito Ricci <vito_ricci_at_yahoo.com>
Date: Thu 08 Jul 2004 - 17:15:15 EST


I use very much Excel in my job and often I've to read Excel data in R. Usually I save Excel file as a .txt file and then I read it in R with read.table().

I find really interesting the suggest of using the function read.xls() in the 'gregmisc' package.

I work also with R in Excel sheets by
R-Com/R-Interface (see:
http://www.sciviews.org/_rgui/projects/RDcom.html)

It has several limits, but for some analysis is helpfull.

Bye
Vito Ricci

Park, Kyong H Mr. RDECOM kyong.ho.park at us.army.mil Wed Jul 7 20:21:42 CEST 2004

Hello, R users,
I am a very beginner of R and tried read.csv to import an excel file after
saving an excel file as csv. But it added alternating rows of fictitious NA
values after row number 16. When I applied read.delim, there were trailing
several commas at the end of each row after row number 16 instead of NA
values. Appreciate your help.

Kyong



Diventare costruttori di soluzioni

Visitate il portale http://www.modugno.it/ e in particolare la sezione su Palese http://www.modugno.it/archivio/cat_palese.shtml



R-help@stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Thu Jul 08 17:21:54 2004

This archive was generated by hypermail 2.1.8 : Fri 18 Mar 2005 - 02:35:00 EST