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

< Previous Comment | Next Comment >Help | Reply To Comment | Reply To Topic
Author Comment/Response
Bill Simpson
05/31/12 1:15pm

This assumes you have put your Excel sheet into your Mathematica folder OR you learn about how to specify paths within Mathematica.

I created a sheet with 8 rows of 2 columns similar to what you described

In[1]:= allrows=Import["Book1.xls"]

Out[1]= {{1.,2.},{2.,5.},{3.,3.},{4.,4.},{5.,1.},{6.,8.},{7.,3.},{8.,7.}}

Now drop the first 3 rows

In[2]:= restrows=Drop[allrows,3]

Out[2]= {{4.,4.},{5.,1.},{6.,8.},{7.,3.},{8.,7.}}

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 Comment | Next Comment >Help | Reply To Comment | Reply To Topic