[R] Import Data from Excel
David Winsemius
dwinsemius at comcast.net
Thu Aug 16 01:07:30 CEST 2012
On Aug 15, 2012, at 2:04 PM, li li wrote:
> Dear all,
> I want to import just part of an excel data file into R.
> I would like to have the data imported without
> rownames or colume names.
> I used read.delim("clipboard", header=F). Somehow even though
> I added the argument "header=F", I still have the row names V1,
> V2, ...,
> Does anyone know how to fix this?
> Thanks very much in advance.
You could use readLines() or you could use scan().
Perhaps:
input <- scan(file="clipboard", what="numeric")
If you know the number of columns, say 10, it could be:
inpmat <- matrix( scan(file="clipboard", what="numeric"), ncol=10)
--
David Winsemius, MD
Alameda, CA, USA
More information about the R-help
mailing list