Mathematica 9 is now available
Student Support Forum
-----
Student Support Forum: 'Isolating Imported Data from Excel' topicStudent Support Forum > General > "Isolating Imported Data from Excel"

< Previous CommentHelp | Reply To Comment | Reply To Topic
Author Comment/Response
Michael
05/31/12 8:51pm

You can try Span:

d=Import[xlsfile,"Data"];
d[[1,30;;-1]]

Notes:
1. d[[1]] = first worksheet
2. d[[1, j]] = j-th row of first worksheet
3. d[[1,30;;-1]] = rows 30 to last of first worksheet

URL: ,

Subject (listing for 'Isolating Imported Data from Excel')
Author Date Posted
Isolating Imported Data from Excel Anne 05/31/12 08:10am
Re: Isolating Imported Data from Excel Bill Simpson 05/31/12 1:15pm
Re: Isolating Imported Data from Excel Michael 05/31/12 8:51pm
< Previous CommentHelp | Reply To Comment | Reply To Topic