[R] html excel file

From: Stefan Semmeling <trittihn_at_web.de>
Date: Thu 19 Jan 2006 - 20:38:18 EST


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@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 Received on Thu Jan 19 20:46:26 2006

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:42:06 EST