I'm trying to import data from single cells of Excel 2007/2010 worksheets using, for example, the following syntax:
import Mysheet.xlsx range="Myrange!H35:H35" @freq a 2010 @rename series01 myseries
Unfortunately specifying only the top left cell (H35) the import range is automatically extended to the other non-empty cells adjacent to the H35.
This seems to be a specifice feature of the "range" option.
I wonder if it's possible to specify the range option in an alternative way or if exists a workaround in order to read single cells.
Thank you very much for your help,
Roberto
import from xlsx worksheet
Moderators: EViews Gareth, EViews Moderator
-
- EViews Developer
- Posts: 161
- Joined: Wed Sep 17, 2008 10:39 am
Re: import from xlsx worksheet
You're right. We're not distinguishing between a single cell and a range with the start and end being the same cell.
Here's a way that I think you can do what you want. Read two columns, then toss out the second one:
import Mysheet.xlsx range="Myrange!H35:I35" @freq a 2010 @keep series01 @rename series01 myseries
(I admit this seems kind of awkward, but changing the current behaviour would require some serious thought).
Here's a way that I think you can do what you want. Read two columns, then toss out the second one:
import Mysheet.xlsx range="Myrange!H35:I35" @freq a 2010 @keep series01 @rename series01 myseries
(I admit this seems kind of awkward, but changing the current behaviour would require some serious thought).
Return to “Suggestions and Requests”
Who is online
Users browsing this forum: No registered users and 17 guests