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.
Import data from excel -
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- EViews Developer
- Posts: 789
- Joined: Tue Sep 16, 2008 3:00 pm
- Location: Irvine, CA
Re: Import data from excel -
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:
Steve
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
Who is online
Users browsing this forum: No registered users and 19 guests