[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