Re: [R] Excel export into R

From: <>
Date: Thu, 06 Mar 2008 10:38:32 +0000

> 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")

See the help page for read.csv

...and the R Data Import/Export manual

Two things to remember:
1. It will be much more straightforward if you save your excel spreadsheet as a CSV file, rather than the Excel native format. 2. read.csv will import the data as a data frame rather than a vector, and will by default coerce the strings to factors.


Mathematical Sciences Unit

ATTENTION: This message contains privileged and confidential inform...{{dropped:20}} mailing list PLEASE do read the posting guide and provide commented, minimal, self-contained, reproducible code. Received on Thu 06 Mar 2008 - 10:41:12 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 - 11:30:19 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.

list of date sections of archive