[R] Importing an Excel file

Petr Pikal petr.pikal at precheza.cz
Thu Jul 8 14:18:03 CEST 2004


If you do not have complicated items with spaces and special 
characters and you want some easy copiing on fly just issue in R


after selecting an area in Excel file and pressing Ctrl-C


On 8 Jul 2004 at 9:15, Vito Ricci wrote:

> 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 at 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

Petr Pikal
petr.pikal at precheza.cz

More information about the R-help mailing list