[R] html excel file

Stefan Semmeling trittihn at web.de
Thu Jan 19 10:38:18 CET 2006


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




More information about the R-help mailing list