Import data from excel -

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

denolo
Posts: 3
Joined: Tue Dec 20, 2016 7:20 am

Import data from excel -

Postby denolo » Thu Feb 25, 2021 1:56 am

Hi,

I am often importing time series data from excel files that are constantly extended (so, new observations become available on a regular frequency).

Is there a way in eviews to import these data without setting the range each time? In other words, can eviews automatically detect the last observation in an excel if I define the location (file, sheet and cell) of the first observation.

Example
import source.xls range="sheet1!B3:B100" @freq M 1985

Currently, I am setting the last observation for each import command manually (in this case "B100) as it changes with each update of the source file. This takes some time especially with many source files.

Many thanks.

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

Re: Import data from excel -

Postby EViews Steve » Thu Feb 25, 2021 8:38 am

No, not for file, sheet, & cell.

However, if the layout of your data on your sheet is simple, and you only have a single group of data on each sheet, you could try and see if EViews will recognize your data range automatically if you only specify the sheet name in the range, like this:

Code: Select all

import source.xlsx range=Sheet1 @freq M 1985


Steve


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 13 guests