The RATS Software Forum

Dear Tom, I do have to read in a quite large Excel-Database which is actualized frequently. The name of the series is in the first column, followed by descriptions, an the data starts in column 14.
Rats can read in the Excel file, but produces an enormous amount of error Messages (due to the descriptions in between and the data format which is m1.99). I can not change the structure of the database. Is there any possibility to delete the error messages in the output window? Up to now i do this manually.

Thanks a lot

gilbril

Can't you use the TOP, LEFT, BOTTOM and RIGHT options on DATA to skip around the non-data information?

The Problem is that I neeed the first column to name the series. Therefore I don't know how to skip around without omitting the first column.

Thanks

gilbril

It sounds like you need

ORG=ROWS,LEFT=14,NOLABELS

then list the series names on the DATA instruction (in order).