suppressing Error Messages
suppressing Error Messages
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
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
Re: suppressing Error Messages
Can't you use the TOP, LEFT, BOTTOM and RIGHT options on DATA to skip around the non-data information?
Re: suppressing Error Messages
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
Thanks
gilbril
Re: suppressing Error Messages
It sounds like you need
ORG=ROWS,LEFT=14,NOLABELS
then list the series names on the DATA instruction (in order).
ORG=ROWS,LEFT=14,NOLABELS
then list the series names on the DATA instruction (in order).