import programming command

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

lomfy
Posts: 36
Joined: Mon Jul 18, 2011 11:51 pm

import programming command

Postby lomfy » Thu Apr 25, 2013 4:50 am

Hey there!
I intend to automate the import of data from an .xls to a workfile.
Using the "import"-command, the system starts to take the data from upper left cell (a1).
Is there a possibility to define the upper left cell where the import should start? I know you can define the upper left cell with the "read"-command,
can you also du this with "import"?
(I some descriptive variables in the leftmost columns and upper rows, the actual time series block starts at cell d3)
Many thanks!
Wolfgang

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

Re: import programming command

Postby EViews Gareth » Thu Apr 25, 2013 7:26 am

You can use the RANGE argument to specify the range of cells you wish to import.

Code: Select all

import myfile.xls range="sheet1!a1:15"

lomfy
Posts: 36
Joined: Mon Jul 18, 2011 11:51 pm

Re: import programming command

Postby lomfy » Thu Apr 25, 2013 8:36 am

jap, that works just fine! thanks a lot!!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests