[R] Importing an Excel file

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


Hi

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

read.delim("clipboard")

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

Cheers
Petr


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