Re: [R] Excel export into R

From: jim holtman <jholtman_at_gmail.com>
Date: Wed, 05 Mar 2008 19:08:41 -0500

There are a number of ways for importing from EXCEL. For example if you were to create a CSV file for EXCEL, you can read it like:

> x <- read.table('/tempxx.txt.r', header=TRUE, as.is=TRUE)
> x

  Control

1  543_BU
2  123_AT
3  432_CU


On Wed, Mar 5, 2008 at 6:42 PM, Keizer_71 <christophe.lo_at_gmail.com> wrote:
>
> Hello,
>
> I have this in excel
>
> Control
> 543_BU
> 123_AT
> 432_CU
>
>
> I want to be able to import to R so that it will read like this
>
> c<-c("543_BU","123_AT","432_CU")
>
> output:
> [1] "543_BU" "123_AT" "432_CU"
>
> This is just a short version. I have about 200000 rows and i need a simpler
> way instead of typing each one.
>
> thanks
> --
> View this message in context: http://www.nabble.com/Excel-export-into-R-tp15863252p15863252.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help_at_r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

-- 
Jim Holtman
Cincinnati, OH
+1 513 646 9390

What is the problem you are trying to solve?

______________________________________________
R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Thu 06 Mar 2008 - 00:10:54 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 06 Mar 2008 - 00:30:19 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive