Found an alternative that is more compact than my earlier suggestion:
Import["example-dataset.xlsx",{"Dataset",1,1;;16,{2,4}},"HeaderLines"->1]
Thanks very much! But do you think that SkipLines can be used to simply ignore the rest of the sheet? As I said in the question, SkipLines->17;;?
SkipLines->17;;
It seems that it is not possible to use Span in the "SkipLines" option
Span
SkipLines
Before trying to specify ranges to the SkipLines option, I think I first need to understand its usage.
Suppose I want to skip lines 5, 6 and 7.
Then why neither "SkipLines" -> {{5, 6, 7}} nor "SkipLines" -> {5, 6, 7} work?
"SkipLines" -> {{5, 6, 7}}
"SkipLines" -> {5, 6, 7}
By the way, see Rohit Namjoshi comment for a similar question I asked.
The documentation for "SkipLines" refers only to ranges that start from the first line
Try this to remove the unwanted lines:
ds=Import["example-dataset.xlsx",{"Dataset",1,All,{1,2,4}},"HeaderLines"->{1,1}][[1;;15]]
Getting rid of the first column:
Normal[ds] // Values // Dataset
