[R] Excel export into R

Richard.Cotton at hsl.gov.uk Richard.Cotton at hsl.gov.uk
Thu Mar 6 11:38:32 CET 2008


> 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
?read.csv

...and the R Data Import/Export manual
http://cran.r-project.org/doc/manuals/R-data.html

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.

Regards,
Richie.

Mathematical Sciences Unit
HSL


------------------------------------------------------------------------
ATTENTION:

This message contains privileged and confidential inform...{{dropped:20}}



More information about the R-help mailing list