Re: [R] Importing an Excel file

From: Petr Pikal <petr.pikal_at_precheza.cz>
Date: Thu 08 Jul 2004 - 22:18:03 EST


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@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@precheza.cz



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 22:25:21 2004

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