Syntax for sheet and cell reference for range options in wf

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

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

please_work
Posts: 8
Joined: Wed Dec 15, 2010 9:07 am

Syntax for sheet and cell reference for range options in wf

Postby please_work » Mon May 09, 2016 5:55 am

Hello,

I was wondering if it was possible to provide EViews with both a sheet and cell reference when using wfopen for Excel files.

In the help documents, I have found examples for one or the other (e.g., range="Cleaned Sheet" and range=C5) but not for both at the same time.

Is it possible? If so, what is the correct syntax?

Many thanks

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

Re: Syntax for sheet and cell reference for range options in

Postby EViews Gareth » Mon May 09, 2016 6:13 am

EViews just uses standard Excel range/reference syntax.

https://support.office.com/en-us/articl ... another_wo

please_work
Posts: 8
Joined: Wed Dec 15, 2010 9:07 am

Re: Syntax for sheet and cell reference for range options in

Postby please_work » Mon May 09, 2016 6:36 am

Perfect - thank you!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests