Page 1 of 1

importtbl - Can't set range for excel import

Posted: Mon Sep 14, 2015 10:54 am
by fboralli
EViews 9 32bit build jun 24 2015

If I run this code :

Code: Select all

importtbl(name=folhas) cv1.xlsx range="graf!a1:z100"
I get this error:
'cv1.xlsx range=""graf!a1:z100' is not a legal file name in
"IMPORTTBL(NAME=FOLHAS) CV1.XLSX
RANGE="GRAF!A1:Z100"".

and I have been unable to set a range for my excel sheet.
If I run this code below, it runs fine:

Code: Select all

importtbl(name=fls) cv1.xlsx

Re: importtbl - Can't set range for excel import

Posted: Mon Sep 14, 2015 10:58 am
by EViews Gareth
Could you update to the latest version and see if you're still having issues?

Re: importtbl - Can't set range for excel import

Posted: Mon Sep 14, 2015 11:06 am
by fboralli
I am not the administrator of the machine running eviews, and also, it does not have direct access to the internet, blocking the use of the auto update feature.
If possible, I would rather not update the version on every update, because it is a somewhat difficult process for me.

Re: importtbl - Can't set range for excel import

Posted: Mon Sep 14, 2015 11:18 am
by EViews Gareth
Understood, but there is no way for us to fix the bug without being able to update your copy of EViews.

Re: importtbl - Can't set range for excel import

Posted: Mon Sep 14, 2015 11:30 am
by fboralli
Can you try to reproduce this error on the current version?

Re: importtbl - Can't set range for excel import

Posted: Mon Sep 14, 2015 11:35 am
by EViews Gareth
I was unable to replicate it on the current version.