Excel 2010

[inno63]

We're in the middle of migrating all our users to Office 2010 32-bit. We have run in to some problems. The formula below works perfect with an Excel 2003 file. If I save the file to a XLSX-file instead and run the program again I get the following error.

KPIF is not defined in "DO_KPIF.X12(MODE=M, SAVE=D11)"

Is Eviews 7.1 compatible with Excel 2010?

Formula:
for %serier kpif ulc tcw op lp sgrad kpitcw ranta op_usd lp_usd
{%serier}.x12(mode=m, save=d11)
next

[EViews Gareth]

I'm confused. There is nothing in that code that you posted that has anything to do with Excel files, is there?

[inno63]

Hi

No, that is the code from Eviews. Here's the whole code. In this example with a XLS file. If I change that line to read from the XLSX file instead, it doesn't work.

%startobs="1980:1"

%fobs ="1995:1"
%sobs="2010:4"
%endobs="2013:4"
%fpobs="2011:1"

wfcreate ecm q 1980q1 2013q4
smpl %startobs %endobs
read(b2,s=blad1) C:\test\test.xls 14

for %serier kpif ulc tcw op lp sgrad kpitcw ranta op_usd lp_usd
{%serier}.x12(mode=m, save=d11)
next

smpl %fobs %sobs

'equation ecm.ls dlog(kpif) c dlog(op) dlog(tcw(-2)) log(kpif(-1)) log(op(-1)) log(lp(-1)) log(tcw(-1)) log(ulc(-1)) dummy20031 @seas(1) @seas(2) @seas(3)

equation ecm.ls dlog(kpif) c dlog(kpitcw) dlog(tcw(-1)) dlog(tcw(-2)) log(kpif(-1)) log(lp_usd(-1)) log(tcw(-1)) log(ulc(-1)) dummy20031 @seas(1) @seas(2) @seas(3)

equation are.ls dlog(kpif) c dlog(kpif(-1)) dlog(kpif(-4)) @seas(1) @seas(2) @seas(3)

smpl %fpobs %endobs

ecm.forecast kpif_ecm_f
are.forecast kpif_are_f

smpl %fobs %endobs

for %serier kpif kpif_ecm_f kpif_are_f
genr {%serier}_yoy=@pcy({%serier})
next

[EViews Gareth]

The READ command doesn't support .XLSX files. Use WFOPEN or IMPORT instead.

[fmgoto]

Does this reply apply to EV7? Can I READ a XLSX file into Eviews (with the command READ)?

How?

Thanks.

[EViews Gareth]

The READ command does not support .XLSX files in any version of EViews.

[fmgoto]

Thanks.

[EViews Glenn]

Note that with the exception of reading transposed data, the WFOPEN, PAGELOAD, and IMPORT commands offer all of the features of the older READ command and much more...As Gareth pointed out, these new functions all support the reading of .XLSX files.