Re: [Gretl-users] Open .xls files
On Tue, 8 Sep 2009, Henrique wrote:
I'm trying to open a specific tab in a Excel spreadsheet using a
Gretl
script file:
open "/Users/henrique/Projetos/C�mbio de Equil�brio/Dados/Previs�es/4p.PEL -
Previsto.xls" --sheet=2 --rowoffset=1
And I'm getting the following output:
One or more variable names are missing.
Perhaps you need to adjust the starting column or row?
Error executing script: halting
> open "/Users/henrique/Projetos/C�mbio de Equil�brio/Dados/Previs�es/4p.PEL
- Previsto.xls" --sheet=2 --rowoffset=1
What's wrong?
I don't know without seeing your xls file. I get correct results
here opening xls with --sheet and --rowoffset specifications,
provide those specifications are right, i.e., in this case row 2
in sheet 2 contains variable names, starting in column 1, and
subsequent rows contain data.
You might want to check that the file doesn't contain "junk" off
screen to the right of the area you want gretl to read.
Allin Cottrell