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
import programming command
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: import programming command
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
jap, that works just fine! thanks a lot!!
Who is online
Users browsing this forum: No registered users and 2 guests
