Using import/wfopen instead of read

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

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

Re: Using import/wfopen instead of read

Postby EViews Gareth » Tue Aug 14, 2018 6:20 am

Yes, it does.
Follow us on Twitter @IHSEViews

farrel
Posts: 108
Joined: Thu Sep 18, 2008 11:13 pm

Re: Using import/wfopen instead of read

Postby farrel » Wed Aug 15, 2018 2:04 am

EViews Gareth wrote:Yes, it does.


I found that Eviews works with opened Excel only if I switch on "Share Workbook" in excel options (.xlsx).
Is this the way how do you enable Eviews to work with opened excel?

farrel
Posts: 108
Joined: Thu Sep 18, 2008 11:13 pm

Re: Using import/wfopen instead of read

Postby farrel » Mon May 10, 2021 12:07 am

Dear Gareth,

I would like to return to the topic on loading data fom Excel.
I need the feature to download the data from Excel, when Excel is open. From you previous posts I understand that it should be possible...
However, I get the error "Sharing violation for file ..."

pic1.JPG
pic1.JPG (52.54 KiB) Viewed 8144 times


I have tested various ways - i) xls vs xlsx; ii) import vs wfopen. Nothing works, unless I close Excel file.

Shall I configure Excel in some specific way? in order to be able to read data from an opened Excel ... or maybe I need to force Eviews somehow to "intrude" Excel?

N.B. I can partly overcome the problem by using "shared workbook" feature enabled, but this is not a solution currently, since under this feature Excel restricts various features in it (e.g. not possible to make charts..)

Andrejs

EViews Steve
EViews Developer
Posts: 788
Joined: Tue Sep 16, 2008 3:00 pm
Location: Irvine, CA

Re: Using import/wfopen instead of read

Postby EViews Steve » Mon May 10, 2021 8:55 am

Are you running EViews on the same machine as Excel? Importing a file that is already open in Excel only works if EViews can talk to Excel directly and that usually means they both have to be running on the same machine.

Otherwise, you'll have to close the file or open it in shared mode like you already discovered.

farrel
Posts: 108
Joined: Thu Sep 18, 2008 11:13 pm

Re: Using import/wfopen instead of read

Postby farrel » Mon May 10, 2021 11:33 pm

in my case, Eviews doesn't read opened Excel even running on the same computer...
Thanks for this point anyway. My acute need actually was running Eviews and Excel on different machines.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 12 guests