[Gretl-users] ODS importer

Allin Cottrell cottrell at wfu.edu
Wed Nov 7 17:39:02 EST 2007


On Wed, 7 Nov 2007, Sven Schreiber wrote:

> <just sent Allin a file off list where the top two rows are empty, the
> third row holds the labels, and then the actual data start at row 4>
> 
> Actually, if I tell gretl to start reading at row 2 (instead of 3), I
> get a strange error: 'sheet row 2, column 2("const"): expected date
> string but found numerical value' (where the row-2/col-2-cell in fact is
> empty).

Thanks for the file, very helpful.

I didn't realize ODS does "number-row-repeated" as well as 
"number-column-repeated".  The importer in CVS/snapshot should now 
work better.

However, on the date strings, I don't really feel like putting 
a lot of work into fixing up data that are written back to front!
(These data start in 2006 and end in 1997.)  That can be fixed 
using sortby() followed by setobs.

Allin.


More information about the Gretl-users mailing list