Skip to content

Excel export into R

2 messages · Richard Cotton, Keizer_71

#
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}}
#
Hi Richie,

I apologize. I thought i deleted this thread since it is resolved by using
scan() function. 

thank you again,
Kei
Richard Cotton wrote: