[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