importtbl - Can't set range for excel import

For notifying us of what you believe are bugs or errors in EViews.
Please ensure your copy of EViews is up-to-date before posting.

Moderators: EViews Gareth, EViews Moderator

fboralli
Posts: 20
Joined: Tue Feb 10, 2015 1:52 pm

importtbl - Can't set range for excel import

Postby fboralli » Mon Sep 14, 2015 10:54 am

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 

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13318
Joined: Tue Sep 16, 2008 5:38 pm

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

Postby EViews Gareth » Mon Sep 14, 2015 10:58 am

Could you update to the latest version and see if you're still having issues?
Follow us on Twitter @IHSEViews

fboralli
Posts: 20
Joined: Tue Feb 10, 2015 1:52 pm

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

Postby fboralli » Mon Sep 14, 2015 11:06 am

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.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13318
Joined: Tue Sep 16, 2008 5:38 pm

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

Postby EViews Gareth » Mon Sep 14, 2015 11:18 am

Understood, but there is no way for us to fix the bug without being able to update your copy of EViews.
Follow us on Twitter @IHSEViews

fboralli
Posts: 20
Joined: Tue Feb 10, 2015 1:52 pm

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

Postby fboralli » Mon Sep 14, 2015 11:30 am

Can you try to reproduce this error on the current version?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13318
Joined: Tue Sep 16, 2008 5:38 pm

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

Postby EViews Gareth » Mon Sep 14, 2015 11:35 am

I was unable to replicate it on the current version.
Follow us on Twitter @IHSEViews


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 33 guests