[R] html excel file

Petr Pikal petr.pikal at precheza.cz
Thu Jan 19 14:09:14 CET 2006


Hi
your question is a bit cryptic. What file you want to read?

xls or some exported file from Excel?

There is many different ways how to read data into R.

See
read.table, RODBC, R data Import Export Manual....

I personally use

in Excel 
select the data with header and
Ctrl-C

in R

myfile <- read.delim("clipboard")

HTH
Petr





On 19 Jan 2006 at 10:38, Stefan Semmeling wrote:

From:           	"Stefan Semmeling" <trittihn at web.de>
To:             	<r-help at stat.math.ethz.ch>
Date sent:      	Thu, 19 Jan 2006 10:38:18 +0100
Subject:        	[R] html excel file

> hallo,
> 
> i have a problem reading in the above mentioned kind of a file.
> does anybody know an easy way how to read it in?
> i can save it as a text file that looks like:
> 
> Datum des Fixings
> Restlaufzeit
> 
> 
> 1 Jahr
> 2 Jahre
> 3 Jahre
> 4 Jahre
> 5 Jahre
> 6 Jahre
> 7 Jahre
> 8 Jahre
> 9 Jahre
> 10 Jahre
> 12 Jahre
> 15 Jahre
> 13.01.06
> 2.819
> 2.983
> 3.073
> 3.137
> 3.194
> 3.247
> 3.302
> 3.355
> 3.409
> 3.459
> 3.548
> 3.649
> 12.01.06
> 2.847
> 3.013
> 3.102
> 3.164
> 3.217
> 3.268
> 3.322
> 3.373
> 3.426
> 3.475
> 3.564
> 3.665
> ...
> 
> after skipping the first four lines i want to read it in while the
> first 12 lines are the heades the next is the date followed by the
> singel values...(these lines are always repeated)
> 
> it is supposed to look like 
> 
>           1    2    3    4    5    6    7    8    9    10    12    15
> datum1    a    b    c    d    e    f    g    h    i    j	 k      l  
> datum2    a    b    c    d    e    f    g    h    i    j     k      l 
>  ...
> 
> i tried to read it in as a normal excel file but it didn´t work out
> the way it was supposed to
> 
> thank you for helping!!!
> 
> stefan
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html

Petr Pikal
petr.pikal at precheza.cz




More information about the R-help mailing list