[Limdep Nlogit List] Reading Excel data file

[William Greene]

Colleagues: LIMDEP/NLOGIT cannot directly read a version 2007 .xlsx
file. Worse, Excel 2007 creates a garbage filled filled file that 
limdep is also unable to read when you try to create a Version 2003
spreadsheet file with Save As...  The work around is to save the file
as a .csv file, then, if need be, manually alter the line of names at
the top so that it contains lines with 80 or fewer characters. Then,
read the file as an ascci date file, with ;NAMES=n in the command, 
where n is the number of names lines you created.  A more robust solution,
at least for now, is a current copy of Stat Transfer, which can translate
.xlsx to .lpj.
Regards,
/Bill Greene

----- Original Message -----
From: "Ralph Okafor" <okafor at ncat.edu>
To: "Limdep and Nlogit Mailing List" <limdep at limdep.itls.usyd.edu.au>
Sent: Thursday, May 28, 2009 4:01:09 PM GMT -05:00 US/Canada Eastern
Subject: Re: [Limdep Nlogit List] Reading Excel data file

I experienced that some months ago. Open the 2003 excel file and scroll 
down. Some where in the middle of the file you will see some empty 
rolls. Block the rolls,delete and then save.

Steven Yen wrote:
> Hi all
> What is the latest about reading Excel data file? Limdep reads Excel 
> files previously prepared with Excel 2003. But when I saved an Excel 
> 2007 (.xlsx) file into Excel 2003 or Excel 5 (1995) limdep cannot 
> read it. It generates the following error message:
>
> --> read    ;file=e:\abc.xls $
>    Error     9: READ - error or end of file occurs while reading data set.
>
> Bottom line is limdep does not like anything from Excel 2007.
>
> Any clues? Thank you.
>
>
> Steven T. Yen
> http://web.utk.edu/~syen/
> Check out our postdoc opening at:
> http://web.utk.edu/~syen/postdoc.html
> _______________________________________________
> Limdep site list
> Limdep at limdep.itls.usyd.edu.au
> http://limdep.itls.usyd.edu.au
>   

_______________________________________________
Limdep site list
Limdep at limdep.itls.usyd.edu.au
http://limdep.itls.usyd.edu.au