Simple Question: Dynare/Octave .xls Datafile

This forum is closed. You can read the posts but cannot write. We have migrated the forum to a new location where you will have to reset your password.
Forum rules
This forum is closed. You can read the posts but cannot write. We have migrated the forum to a new location (https://forum.dynare.org) where you will have to reset your password.

Simple Question: Dynare/Octave .xls Datafile

Postby fernandes » Tue Jan 10, 2017 5:12 pm

Hello,

I realize it's a simple question, but I'm not being able to make Dynare (4.4.3)/Octave (3.8.1) read the data on the excel (.xls) file.

I've already installed the IO package, loaded it and set the current directory where the datafile is located, but Dynare is still returning an error message when I try to activate it.

The .mod and .xls files, and the error message (.txt) are attached below. Can someone give me a little help on the matter? Thanks in advance.

P.S: I've pasted the main part of the error message below.

"
Detected XLS interfaces: None.
warning: xlsopen.m: no'.xls' spreadsheet I/O support with available inter

warning: xlsread: some elements in list of return values are undefined
error: y not found in dadosdissert.xls
error: called from:
error: C:\dynare\4.4.3\matlab\read_variables.m at line 104, column 17
error: C:\dynare\4.4.3\matlab\/utilities/dataset\initialize_dataset.m a
error: C:\dynare\4.4.3\matlab\dynare_estimation_init.m at line 475, col
error: C:\dynare\4.4.3\matlab\dynare_estimation_1.m at line 81, column
error: C:\dynare\4.4.3\matlab\dynare_estimation.m at line 89, column 5
error: C:\dynare\4.4.3\dissertacao\dissertacao.m at line 270, column 1
error: C:\dynare\4.4.3\matlab\dynare.m at line 180, column 1
"
Attachments
dadosdissert.xls
(56 KiB) Downloaded 64 times
dissertacao.mod
(1.47 KiB) Downloaded 58 times
error message.txt
(1.74 KiB) Downloaded 75 times
model.txt
(1.47 KiB) Downloaded 67 times
fernandes
 
Posts: 3
Joined: Tue Jan 10, 2017 4:58 pm

Re: Simple Question: Dynare/Octave .xls Datafile

Postby jpfeifer » Tue Jan 17, 2017 10:38 am

That seems to be a bug in Octave 3.8.1. If Excel is not installed, you can only work with xlsx files, not xls.
------------
Johannes Pfeifer
University of Cologne
https://sites.google.com/site/pfeiferecon/
jpfeifer
 
Posts: 6940
Joined: Sun Feb 21, 2010 4:02 pm
Location: Cologne, Germany

Re: Simple Question: Dynare/Octave .xls Datafile

Postby fernandes » Mon Jan 30, 2017 5:36 pm

Thanks a lot for the help!!
fernandes
 
Posts: 3
Joined: Tue Jan 10, 2017 4:58 pm


Return to Dynare help

Who is online

Users browsing this forum: Google [Bot] and 7 guests