Page 1 of 1

import programming command

Posted: Thu Apr 25, 2013 4:50 am
by lomfy
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

Re: import programming command

Posted: Thu Apr 25, 2013 7:26 am
by EViews Gareth
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"

Re: import programming command

Posted: Thu Apr 25, 2013 8:36 am
by lomfy
jap, that works just fine! thanks a lot!!